Since I am so munificent today I decided to have 3 teasers in this one post.
What will be the output or error message if you would run this code?
DECLARE @ CHAR(2)
DECLARE @@ CHAR(1)
SELECT @ ='@@'
SELECT REPLACE(@,COALESCE(@@,NULLIF(@@ ,'@'),@@,'@','@@'),@)
What will be the result of the following query?
DECLARE @i INT
SELECT @i = 100000
What is the 5th isolation level in SQL Server 2000 and where can you find it
What is the 6th isolation level in SQL Server 2005/2008 and where can you find it?
These are the isolation levels you know with the SQL server versions in parentheses
READ UNCOMMITTED (2000 -2008)
READ COMMITTED (2000 -2008)
REPEATABLE READ (2000 -2008)
SERIALIZABLE (2000 -2008)
SNAPSHOT (2005 -2008)
BTW the READ_COMMITTED_SNAPSHOT option does NOT count
SPOILER For Teaser 3 below!!!!!
I decided to give the answer for this one since you can't just run the code to see it yourself
It is in BOL by the way ;-)
DTS Package Properties (Advanced Tab)
Configuring Properties for DTS Transactions
Chaos means anything goes, it is used to connect to other system which don't have the same isolation levels as SQL Server