Viewing 15 posts - 37,186 through 37,200 (of 49,566 total)
August 10, 2009 at 12:07 pm
marwenG (8/10/2009)
select @nbre_Part=count(*)from Inserted
select @nbre_Part=count(*)
from updated
i
There's no such thing as an 'updated' table. The two pseudo-tables visible in triggers are inserted and deleted.
Inserted contains new rows, when the operation is...
August 10, 2009 at 10:06 am
The username and password? It'll be stored in one of the hidden system tables. Offhand, no idea which one and it shouldn't be important. The relevent info is exposed through...
August 10, 2009 at 8:41 am
jcrawf02 (8/10/2009)
GilaMonster (8/10/2009)
Gianluca Sartori (8/10/2009)
Thanks Gail! I'm never patient when it's time to learn something new, especially from you!
Please note I'm asking for an article review, either a technical review...
August 10, 2009 at 8:30 am
jcrawf02 (8/10/2009)
Suggestions for "very terse answers" -Unplug it.
Quit your job.
Run. Now.
Ask Jeff.
I've several times been tempted, when reading a really long question that's of the form 'Is it possible...'...
August 10, 2009 at 8:29 am
rja.carnegie (8/10/2009)
August 10, 2009 at 8:28 am
Grant Fritchey (8/10/2009)
I meant cure as in, not give the patient a different form of terminal cancer, but as in, remove the cancer.
RotFL
Good one.
August 10, 2009 at 7:51 am
Wesley Brown (8/10/2009)
August 10, 2009 at 7:48 am
rja.carnegie (8/10/2009)
August 10, 2009 at 7:41 am
Grant Fritchey (8/10/2009)
In my haste I even missed things, like using a WHILE loop as a cure for cursors... when will that die?
Well, they are a cure for cursors. The...
August 10, 2009 at 7:38 am
ta.bu.shi.da.yu (8/10/2009)
I'm curious... would the selectivity of an index influence the execution plan when an inequality predicate is used?
Possibly. Selectivity's difficult with inequalities, especially when there's parameters or variables...
August 10, 2009 at 7:28 am
GSquared (8/10/2009)
August 10, 2009 at 7:23 am
ta.bu.shi.da.yu (8/10/2009)
August 10, 2009 at 6:59 am
ta.bu.shi.da.yu (8/10/2009)
But both of these are anti-semi-joins, which means that I don't actually think you need the top 1.
What TOP 1?
August 10, 2009 at 6:44 am
Gianluca Sartori (8/10/2009)
Thanks Gail! I'm never patient when it's time to learn something new, especially from you!
Please note I'm asking for an article review, either a technical review or comments...
August 10, 2009 at 6:18 am
Viewing 15 posts - 37,186 through 37,200 (of 49,566 total)