Viewing 15 posts - 1 through 15 (of 40 total)
Hrm... I using this in a sproc to gather data from other servers, but it doesn't like using a variable as the server name:
SELECT @version=version FROM OPENQUERY(@SERVER_NAME,'SELECT @@MicrosoftVersion / 0x01000000...
November 18, 2009 at 9:12 am
Good catch! And this works, thanks.
November 18, 2009 at 8:53 am
Oh no, I'm not programming anything... just something I wanted to find information about. And since all the forums I belong to are sql centric, I didn't really have many...
June 14, 2009 at 8:16 am
Very sneaky UMG Developer. That's a very hot solution. Right when I thought I knew a cool trick someone one-ups me.
ewwww... Crystal Reports. Fair Enough, Russ.
May 13, 2009 at 12:04 pm
Hey russ,
this is a pretty common question, with several different solutions. Why exactly do you need to concatenate all the rows on sql server? Typically this is something done on...
May 13, 2009 at 11:43 am
I'm *mostly* certain you're right. I'll check with some co-workers. This isn't my forte.
I'm surprised noone else has responded yet.
April 29, 2009 at 12:07 pm
I never thought about anything like this before.
Is there a way a query batch can trigger a process in another thread of the server? Ie - rebuild an rss feed...
April 29, 2009 at 12:01 pm
WanyeS, your link looks broken. I also couldn't find the BOL NULL page myself.
The wiki page is a pretty good read though -> http://en.wikipedia.org/wiki/Null_(SQL)
April 27, 2009 at 8:20 am
Depending on the size of your project and what exactly you're using the information for. However, handling of NULLs should be a common, and expected, practice. Furthremore, you don't want...
April 27, 2009 at 8:17 am
I'm a little less than a year into this whole DBA mess and I'm only a college intern, but titles that come to mind:
DBA Liason to Development team
DBA Development Coordinator
But...
April 15, 2009 at 7:22 am
edit: Narrowing the error more:
Anyone know how you're supposed to enumerate an attribute list?
Also, everytime I post XML it disappears in the post, and I have to search and replace...
March 30, 2009 at 12:35 pm
I haven't worked in the field that long, I'll take your word on the inability of others to use their heads. We're in IT, we're not the users! I wish...
March 30, 2009 at 8:52 am
My mistake RBarryYoung, I tackeld the wrong argument.
Preaching the evil of cursors then using them yourself for particular instances can be a mixed message for neophytes. I'd say if you...
March 30, 2009 at 8:16 am
I'm going to have to side with the cursor argument on this one.
A one time use/db script probably isn't going to take the server down.
The probability of overfilling an nvarchar(MAX)...
March 30, 2009 at 6:35 am
Viewing 15 posts - 1 through 15 (of 40 total)