http://sqlblog.com/blogs/denis_gobo/archive/2007/06/15/1471.aspxSince I am so munificent today I decided to have 3 teasers in this one post. Teaser 1 What will be the output or error message if you would run this code? ----------------------- DECLARE @ CHAR ( 2 ) DECLARE @@ CHAR ( 1 ) SELECT @ = '@@' SELECT REPLACEenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/denis_gobo/archive/2007/06/15/1471.aspx#1476Fri, 15 Jun 2007 15:04:01 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:1476Denis Gobo<p>Decided to give the anwer for teaser 3</p> http://sqlblog.com/blogs/denis_gobo/archive/2007/06/15/1471.aspx#1481Sun, 17 Jun 2007 23:04:21 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:1481Adam Machanic<p>Denis,</p> <p>I don't believe that option actually does anything in SQL Server. &nbsp;AFAIK, it's only there so that it can be used with other DBMSs--some of which actually do support it.</p> http://sqlblog.com/blogs/denis_gobo/archive/2007/06/15/1471.aspx#1483Mon, 18 Jun 2007 08:43:31 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:1483Denis Gobo<p>True, I admit I have never used the Chaos isolation level. </p> <p>I primarly deal with SQL Server, Sybase, flat files, Excel files and FoxPro(which thankfully has seen it last version from MS, no more exclusively locked files and other mambo-jumbo ;-) &nbsp;)</p>