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.

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

...

++1 😀

++1

😀

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...

I think the explanation is incomplete and inaccurate.

INNER JOIN returns number of rows from left table...

I get it right, but

+1

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'

...

Thanks!

🙂

Maybe, you miss the UPDATE clause:

declare @mykey int

update top 1 mytable set

@mykey = mykey

where status = 0

print @mykey

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...

paul.knibbs (8/3/2012)

---

All you've proved there is that a 45-character string can't ever be longer than 45 characters. Try adding PRINT @STR1 and you'll see that the string has lost the...

No, the last...

You can't rename a PERSISTED computed column, too!

Why?

I poke the wrong answer, but I learned something new.

Thanks.

😀