Viewing 15 posts - 481 through 495 (of 825 total)
Instead of this syntax:
SELECT I, N
FROM @T
WHERE N > 0.114
AND N < 0.116
I prefer this one:
SELECT I, N
FROM @T
WHERE ABS(N - 0.115) < 0.0000001
It's more...
June 7, 2013 at 2:07 am
Primo Dang (6/6/2013)
Seriously though, varchar(1) really doesn't make much sense to me, I guess char(1) would do the job perfectly and avoid the extra 2 byte overhead.
I disagree with you:...
June 7, 2013 at 1:50 am
palotaiarpad (6/6/2013)
Collation, collation, collation....
If not specified, the default collation always is CASE INSENSITIVE.
June 6, 2013 at 1:40 am
Starting from SQL2000 SET ANSI_NULLS OFF is a real deprecated option.
From BOL:
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly set the...
June 5, 2013 at 1:49 am
SQLRNNR (5/26/2013)
Easy enough - I have done this in the past.
+1
In 80's, on mainfraim I placed the prompt with:
"ADVANCED COBOL '85. COMPILING SOURCE ... SGCONT.CBL"
So, it seemed an everending...
May 27, 2013 at 2:22 am
It's easy, all services of microsoft store data in msdb (that stands for "microsoft database").
May 22, 2013 at 1:53 am
I use this command SELECT INTO to create a table in development environment, then
I use my personal EXEC sp_createtable 'TempTab' to generate the script for creating the table
and in the...
May 10, 2013 at 3:42 am
The question states the batch in the very begining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.
+1
😀
Good qotd, but too...
May 6, 2013 at 1:07 am
Danny Ocean (5/2/2013)
May 3, 2013 at 2:45 am
Rune Bivrin (5/2/2013)
Hugo Kornelis (5/2/2013)
1. If I were to try this code on my system, I would get five errors. All system table (*) names are...
May 2, 2013 at 6:17 am
crussell-931424 (5/1/2013)
Hugo Kornelis (5/1/2013)
Raghavendra Mudugal (5/1/2013)
- Replicate is replicating as needed (the expression is 5 chars and and @s-2...
May 2, 2013 at 1:14 am
What is the difference between the answer 3 and 6?
5, 3, 1
April 23, 2013 at 2:58 am
Bad question! Too much stuff, no value!
It's take too long to check all the script!
April 23, 2013 at 2:22 am
Knut Boehnert (4/18/2013)
Carlo Romagnano (4/18/2013)
Old stuff!Dynamic sql will run better.
Sorry, all you are saying is that a red sky is always better than a green sky. But not why.
Everyone knows...
April 18, 2013 at 2:40 am
Viewing 15 posts - 481 through 495 (of 825 total)