Viewing 8 posts - 1 through 8 (of 8 total)
I agree - many of these are just plain wrong.
August 10, 2009 at 8:39 pm
Your example doesnt make sense. It lists Jim and Smith as firstnames?
You can pivot a table by using case statements or selfjoins, if that is what you are trying to...
January 10, 2005 at 8:24 pm
Are you sure about the answer?
Our server runs 2000, and has only ever had 2000 on it - approx 2 weeks old, and it used the key you claim is...
August 24, 2004 at 9:03 pm
we use an extended sproc to send SMTP mail, as someone else suggested above.
The one we use is xp_smtp_sendmail - do a search for that on google - very simple...
June 2, 2004 at 8:43 pm
I think you will find it is because values for the variables are not known at compile time, and therefore the execution plan is less than optimal ;-). The solution...
June 2, 2004 at 8:16 pm
Rawhides answer is almost exact, but you need to specify the table name as well
set identity_insert dbo.File on
'now insert your rows
set identity_insert dbo.File off
should allow you to do it.
Cheers
Al
June 2, 2004 at 8:10 pm
The trigger doesnt fire so how can it do "no row is inserted..."
This type of question is crap - The answer should be none of the above. If the trigger...
March 8, 2004 at 8:41 pm
Viewing 8 posts - 1 through 8 (of 8 total)