Viewing 15 posts - 16 through 30 (of 117 total)
Lowell (7/2/2013)
July 2, 2013 at 10:47 am
I got my Sp's mixed up. I was thinking of Sparse files.
June 4, 2013 at 3:17 pm
opc.three (5/24/2013)
May 24, 2013 at 7:51 pm
Lowell (5/24/2013)
so CREATE USER [ClarkKent] WITHOUT LOGIN is fine and will work;
but if you put in a slash in the name, a...
May 24, 2013 at 3:23 pm
Jan Van der Eecken (5/22/2013)
ScottPletcher (5/21/2013)
This should "turn off" the identity property:
SELECT *
INTO dbo.newtable
FROM dbo.table
UNION ALL
SELECT TOP 1 (*)
FROM dbo.table
WHERE 1 = 0
Nice one, Scott! Need to remember this.
Agreed. Thanks...
May 22, 2013 at 8:07 am
I'm sorry, I should've mentioned I am deliberately trying to avoid listing out columns. Trying to see if there is a way to populate several QA tables from a production...
May 21, 2013 at 1:19 pm
I was patting myself on the back for not having fallen for any jokes on April Fools day this year...then I read your article a day after it was written...
April 2, 2013 at 5:32 am
Thanks Gail. One of the things in 2008 that flew under my radar.
March 29, 2013 at 9:54 am
I figured out the problem, I had to recreate the Parent/Child group relationship, then add the headers there.
March 15, 2013 at 5:41 pm
First and foremost, you have the ability to do this job. Your past, and diverse experience shows you have the ability to adapt and to learn. The fact that you...
March 4, 2013 at 8:02 am
The SQL test included in this article is not a sophisticated test. However, it can quickly, in 15 minutes or less, and with reasonable success, separate senior SQL developers and...
February 28, 2013 at 5:51 am
Rob-350472 (2/18/2013)
February 18, 2013 at 7:44 am
sandhyarao49 (2/13/2013)
I have a requirement to combine the results of multiple select statements in to a single row.
EX :
query 1 : select count (*) as Col1 from abc where...
February 18, 2013 at 7:02 am
Ian C0ckcroft (2/18/2013)
Thanks Kingston, looks much neater, will try that.Gabriel, its just 6+5 =11 and should be 6 + .5 = 6.5 🙂
I'm sorry I did not make the point...
February 18, 2013 at 6:38 am
Ian C0ckcroft (2/18/2013)
Not...
February 18, 2013 at 6:00 am
Viewing 15 posts - 16 through 30 (of 117 total)