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

😀

Good: Correct answers: 95% (70)

I never saw a qotd with 100% of correct answers.

By the way:

I often use NULLIF when 3rd party application use MAGIC VALUES instead of NULL.

e.g. 1799-12-31 stands for NULL DATETIME.

Here's a generic example to get an actual...