What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD(yy, DATEDIFF(yy, 0, @d)+1, -1)

What will be the outcome of this script?First we create a table with a total of 6000 bytesNext we increase col2 from 1000 to 2000 bytes, this will give us a total of 7000 bytesFinally we add col3 which has 1000 bytes, this will give us a total of 8000 bytes First run these two statements--Total size = 6000CREATE TABLE TestSize (Col1 ...

First create this table CREATE TABLE Teaser (ID int) INSERT Teaser VALUES(1) INSERT Teaser VALUES(2) INSERT Teaser VALUES(1) INSERT Teaser VALUES(2) INSERT Teaser VALUES(NULL) Without running this try to figure out what the result will be SELECT COUNT(*), COUNT(ID), COUNT(DISTINCT ID) FROM Teaser For some more NULL summer fun you can read NULL ...