Viewing 15 posts - 3,751 through 3,765 (of 5,685 total)
GSquared (3/11/2011)
GilaMonster (3/11/2011)
I signed off two official design documents back at the bank as "Database Overlord". No one commented.
I, for one, welcome our new reptilian overlords ....
(Now I can't remember...
March 11, 2011 at 11:27 am
What are you checking for? Existance, a value in TableA being 'x', that it's new?
Need more information on what you're doing to help walk you through how to do...
March 10, 2011 at 11:03 pm
Ummm, the 'select all that apply' choices are a radio button, can only pick one. Not good.
March 10, 2011 at 10:59 pm
jcrawf02 (3/10/2011)
I'm still working on my master plan of successfully naming a project A.C.R.O.N.Y.M., haven't been able to figure that one out yet.
You mean the unit of
Assault Crimes of...
March 10, 2011 at 4:05 pm
I answered wrong but it was a good question. I brainfarted like a few others and went after the 'data', not the log... so you could restore anytime up...
March 10, 2011 at 3:55 pm
p.stevens76 (3/10/2011)
CHEERS CRAIGTHAT WORKED A TREAT. THANKS A LOT
🙂
My pleasure, glad it worked... and thanks for the feedback. 🙂
March 10, 2011 at 2:13 pm
Khades (3/10/2011)
Oh wow, I did not know the magic tables would have that identity even if you don't directly insert/update/delete it, thanks!
I couldn't remember myself because I avoid triggers so...
March 10, 2011 at 1:47 pm
Jeff Moden (3/10/2011)
WayneS (3/10/2011)
and probably more efficient than correlated sub-queries.There's only one way to know, huh? 😉
As usual: It depends...
...and it depends a LOT on the indexing. (The proof...
March 10, 2011 at 1:42 pm
Tom.Thomson (3/10/2011)
Of course there are some real horrors, with getting on for 500 common uses. Acronyms are often a bad idea because they are so thoroughly ambiguous. 😉
I have...
March 10, 2011 at 1:39 pm
CirquedeSQLeil (3/10/2011)
March 10, 2011 at 12:55 pm
Khades (3/9/2011)
How do I get the identity column values from the errorPK table?
Trigger:
The inserted table will carry the identity when you go to insert into ErrorFK.
Check this code for...
March 10, 2011 at 12:45 pm
Hey Jeff,
A bit of research is showing me that this is, at best, a mess.
For example, to deal with doc_ids, apparently you need to use sp_fulltext_keymappings http://msdn.microsoft.com/en-us/library/cc645845.aspx... but that doesn't...
March 9, 2011 at 11:59 am
GilaMonster (3/9/2011)
Craig Farrell (3/9/2011)
Ah, that explains a few things. I'd wondered who'd pissed in your cheerios yesterday, and was just glad it wasn't me. 😉
Oh, I didn't think...
March 9, 2011 at 10:41 am
Khades (3/8/2011)
Except I guess, if I do use a trigger. How do I make it use only those rows that were inserted along with the PK of that table? Do...
March 9, 2011 at 10:26 am
rjohal above is correct, it's most likely got to do with the statistics difference between temp tables and table variables affecting the query plan. Temp tables store more accurate...
March 9, 2011 at 10:11 am
Viewing 15 posts - 3,751 through 3,765 (of 5,685 total)