Viewing 15 posts - 181 through 195 (of 363 total)
[font="Verdana"]Post your Bulk Insert query coz you need to mention (might be, u have already mentioned) FIRE_TRIGGER option inside the WITH clause. Triggers won't fire incase of bulk insert. You...
May 16, 2008 at 6:21 am
[font="Verdana"]Let us know what you are going to do? Coz 1st thing, object can't be create inside UDF.
by the way, the answer for your question is, NO
Mahesh[/font]
May 16, 2008 at 6:00 am
[font="Verdana"]Also make a habit of avoiding subqueries. Instead apply Joins like suggested by Mr. Hasan in his prev post.
Mahesh[/font]
May 16, 2008 at 5:44 am
[font="Verdana"]No. what you can do is, write o/p to file and then print the file.
Mahesh[/font]
May 16, 2008 at 4:26 am
[font="Verdana"]Java script is used to navigate Backward and Forward. for more information on this search for History.go() on dot Net sites. Usually History.go(-1) used to navigate Backward.
Mahesh[/font]
May 16, 2008 at 3:22 am
[font="Verdana"]This question can't be answered on the fly. So, if possible, post some real life data from all the tables with expected o/p.
Mahesh[/font]
May 16, 2008 at 2:10 am
[font="Verdana"]Obviously.
For Delete:
Delete From A Inner Join B On A.Id = B.Id
For Insert in different way like:
Insert Into A (col1, Col2)
Select B.Col1, C.Col2 From B Inner Join C On B.Id =...
May 16, 2008 at 1:43 am
[font="Verdana"]
Table A: 1000 Rows
Table B: 250 Rows
Key question is :
which table should come first when we are going to use JOIN ?
No matter which type of Join you are...
May 14, 2008 at 7:37 am
[font="Verdana"]Then you should post some sample data and all the conditions you needs to apply as well. don't expect the answers on the fly.
Mahesh[/font]
May 14, 2008 at 7:24 am
[font="Verdana"]In case of passing table as a parameter to a SProc XML can be used.
Mahesh[/font]
May 14, 2008 at 7:15 am
[font="Verdana"]Not clear what exactly readable means. Though if I am not wrong do you need something like this ... ?
select * from scan
where boxid = 'RET0018438'
...
May 14, 2008 at 7:09 am
[font="Verdana"]You can not use control statements directly into Select statement. Instead use Case statement. For more information on Case refer BOL
Mahesh[/font]
May 14, 2008 at 7:02 am
[font="Verdana"]
Msg 8115, Level 16, State 8, Line 1
Arithmetic overflow error converting numeric to data type numeric.
From BOL
Severity Levels 11 through 16
These messages indicate errors that can be corrected by the...
May 9, 2008 at 6:14 am
[font="Verdana"]
Location: recbase.cpp : 1375
Are you referencing some DLL build in CPP? Is so, then check at the given line number in the recbase.cpp file. I don't think the mentioned error...
May 9, 2008 at 6:09 am
[font="Verdana"]system Stored Procedure, i.e. sp_depends will help you out. Try it.
Mahesh[/font]
May 9, 2008 at 6:03 am
Viewing 15 posts - 181 through 195 (of 363 total)