Viewing 15 posts - 1 through 15 (of 57 total)
Two things. (1) the use of upper indicates your database should be set to be case insensitive. (2) creating a table doesn't get you out of testing in...
March 17, 2015 at 12:56 am
Sean Pearce (9/16/2014)
And this relates to SQL Server how? I am not here for maths lessons.
I thought it would be a frienfly question, so I picked Amicable numbers...
October 9, 2014 at 1:01 am
bvrolyk (7/17/2013)
In my "real world problem" I need to list the fathers with no children, not...
September 5, 2014 at 9:53 pm
akhamoshioke (5/1/2014)
Comments posted to this topic are about the item <A HREF="/scripts/Orphan+users/109993/">Fix orphaned users after restoring database to another server</A>
A better approach is to get the info from the original...
July 18, 2014 at 7:49 pm
Did you intend for the WITH with a GO before it to be a red herring? I knew you could do the insert, but the question seemed simple and...
June 24, 2014 at 11:49 pm
patrickmcginnis59 10839 (12/9/2013)
December 9, 2013 at 9:41 am
dwain.c (9/26/2013)
The only think I find annoying about them (unless I missed something) is that you can't update them. Need to...
September 29, 2013 at 2:14 am
I got it right, but I wish the date wasn't April Fools day -- it adds a bit of "meta" distraction to the question.
Is it ha, ha fooled you if...
February 4, 2013 at 11:43 pm
Jim P. (1/17/2013)
Any time someone brings up password security I always think of this XKCD commentary[/url]
Except that for a site that you visit once a week, let alone once a...
January 17, 2013 at 7:48 pm
Barry Wright-268269 (1/17/2013)
January 17, 2013 at 11:46 am
SanDroid (12/26/2012)
In order for the elves to find the items
A spatial index is the only right one for this task.
Since Elves do not exist on this Planet/Reality it...
December 26, 2012 at 12:08 pm
Ninja's_RGR'us (3/21/2011)
And just for fun, a recursive CTE solution! :hehe:
DECLARE @t varchar(max);
SET @t = '';
WITH rectags AS
(
SELECT TOP 1 Tag FROM Tags ORDER BY Tag
UNION ALL
(
SELECT ', ' +...
September 28, 2012 at 10:54 am
GilaMonster (12/29/2008)
Aspet Golestanian Namagerdi (12/29/2008)
Is it safe to work with system tables and fallowing TSQL:
If your goal is to corrupt your database and cause downtime and loss of data, sure.
It...
September 20, 2012 at 10:39 am
For instance, I recently said at my workplace that a database backup created on one version of SQL Server could not be restored onto a different version of SQL Server.
Not...
August 6, 2012 at 10:32 am
George H. (6/26/2012)
Why does SQL Server spit the results out in this format rather than in straight binary, like this:
01100001 01100010 01100011 01100100 01100101 01100110 01100111
I apologize if this is...
June 26, 2012 at 11:01 am
Viewing 15 posts - 1 through 15 (of 57 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy