Viewing 15 posts - 91 through 105 (of 148 total)
I answered anything because I know nothing about the execution plan but I wanted to see the answer and read the discussion now, so I tried something... and got...
October 27, 2011 at 7:42 pm
Jan Van der Eecken (10/26/2011)
October 26, 2011 at 5:07 am
Very good question indeed!
Took me a while to understand the "OUTPUT inserted.id" until I modified the query and finaly realised that the ".id" from the "OUTPUT inserted.id" was...
August 26, 2011 at 7:12 pm
Nils Gustav Stråbø (8/22/2011)
Logging in this context is not about logins or permissions, it's about write operations that gets logged in the transaction log. Two completely different things.
oye!:ermm:
That means there...
August 22, 2011 at 3:37 pm
I have a question: how can you execute a T-SQL command if you are not logged
or maybe a better way to address the question would be : What "is...
August 22, 2011 at 7:35 am
cengland0 (7/28/2011)
Whoops, I go this one wrong because I accidentally selected a third option even though it said select two. ...
Don't worry, you are not the only one...:Whistling:
Thanks for...
July 28, 2011 at 8:37 pm
Ninja's_RGR'us (7/28/2011)]
tilew-948340 (7/27/2011)
July 28, 2011 at 8:08 pm
stewartc-708166 (7/28/2011)
You could also have used CASE AND IS NULL, e.g.SET AllComments = CASE WHEN AllComments IS NULL THEN ST.AllComments ELSE AllComments + ', ' + ST.AllComments END
There is a...
July 28, 2011 at 7:35 pm
jason.stephens (7/27/2011)
July 27, 2011 at 8:19 pm
Geniiius (7/27/2011)
What you really need is an aggregate function that does string concatenation. You can build one in CLR and use it like you would use SUM or AVG.
I...
July 27, 2011 at 7:27 pm
tfifield (7/27/2011)
Try adding Comment to the GROUP BY clause:GROUP BY Target_ID, Comment
Todd Fifield
Change nothing on the error message from the merge...
Thanks for trying to help me!
July 27, 2011 at 7:05 pm
"PolciyAdministrator is not a role in the msdb database"
Almost half of the people thought it was a role :w00t:
So very good question! Thanks!
July 22, 2011 at 8:33 pm
J DBA (7/21/2011)
Tx, I'd still like a 2k5 confirmation... am I the only one with a retarded server??? Can't possibly be the case
I get NULL on both 2005...
July 22, 2011 at 5:12 am
I also try the command before (from the time I got SQLserver, I certainly logged once with a bad password!) and after doing a new login with a bad password....
May 26, 2011 at 5:47 am
Got it wrong :doze:
I tought the default scale on decimal would be 2
Should have take time to verify...
Good question, Thanks!
April 18, 2011 at 7:09 pm
Viewing 15 posts - 91 through 105 (of 148 total)