Viewing 15 posts - 541 through 555 (of 825 total)
Stewart "Arturius" Campbell (11/16/2012)
Good question, thanksAnother motivation to use TRY CATCH...
+1
November 16, 2012 at 1:10 am
Best practise: save @@error and @@rowcount to test them later
declare @err int
,@rows int
select 1
SELECT @err = @@error, @rows = @@rowcount
if @err <> 0 or @rows = 0
...
November 16, 2012 at 1:00 am
tteelucksingh (11/13/2012)
Got it wrong though, missed the first select..into statement before the while loop.
I missed the last!
November 14, 2012 at 1:28 am
Boh!!!!!
I do not understand what the question is about, so, how can I answer correctly?
The method 2 is incomplete or bad written.
😎
I do not like qotd too long.
November 8, 2012 at 1:11 am
Remember that SUM may return NULL, so SUM(num1)+SUM(num2) may lead to NULL:
select
sum(num1) AS S1,
sum(num2) AS S2,
sum(num1) + sum(num2) AS S3,
sum(num1 + num2) AS S4
from
...
November 5, 2012 at 4:11 am
L' Eomot Inversé (11/2/2012)
Nice straightforward question.Surprised it's 3 points, though; it's rather easy.
++1 😀
November 2, 2012 at 1:10 pm
vk-kirov (10/30/2012)
Thanks for question about the new feature of MSSQL 2012!
++1
😀
October 30, 2012 at 1:56 am
I get it right, but the explanation is completely wrong. The syntax for IN clause is or specify a subquery or a list of EXPRESSIONS. ONE expression can have multiple...
October 29, 2012 at 2:01 am
If all the rows get matched then the query will act as a cross join.
I think the explanation is incomplete and inaccurate.
INNER JOIN returns number of rows from left table...
September 26, 2012 at 6:15 am
I get it right, but
rVadim (9/20/2012)
DiskIO in sp_Who2 means reads and writes combined, not just reads as question asks.
+1
September 21, 2012 at 1:11 am
You need add the clause "FORMAT" to succeed the second statement!
BACKUP DATABASE TestDatabase_1
TO DISK = 'C:\TestDatabaseBackup.BAK'
WITH COMPRESSION
GO
BACKUP DATABASE TestDatabase_2
TO DISK = 'C:\TestDatabaseBackup.BAK'
...
September 17, 2012 at 4:00 am
Maybe, you miss the UPDATE clause:
declare @mykey int
update top 1 mytable set
@mykey = mykey
where status = 0
print @mykey
August 17, 2012 at 3:02 am
I agree with Steve. C and C++ help to understand how to handle memory/cpu/io/other devices. They help to develop very good performance applications or batch processing.
In 1986, I started with...
August 15, 2012 at 8:16 am
Viewing 15 posts - 541 through 555 (of 825 total)