But have you used 8" floppy disks?

As long as you don't mind incorrect results:

DECLARE @inputValue NVARCHAR(20)

DECLARE @student TABLE

(Id INT PRIMARY KEY IDENTITY(1,1),

StudentName NVARCHAR(50),

StudentResult INT)

INSERT INTO @student

VALUES( 'Hardy',...

Hugo Kornelis (1/4/2011)

---

I replied wrong - I saw the rollback after the truncate, assumed the question intended to test my understanding that a truncate can be rolled back, and then...

Thanks for the question!

Nice easy question, thanks!

Thanks for the question, and thanks Hugo for your explanation.

This question was really easy, as I knew the errors couldn't happen as they were stated, so there was only one...

Thanks for the question!

I think this would fall under the "Halloween Protection" portions of updates and deletes.

For some trivia you can read some about the Halloween problem here.

Brandie Tarvin (12/28/2010)

---

Microsoft is a U.S. Company. The U.S. was a collection of British colonies back in 1752. Hence, the assumption, on the part of the author, that everyone would...

Only correct for 2005 RTM? Can't say as I like this question...

Thanks for the question, and the explanation of why the explanation seemed so weird.

Hugo Kornelis (12/23/2010)

---

I got the question right, assuming that the submitter was unaware of the fact that there is no guarantee for this behaviour. I was then surprised to see...

Thanks for the question.

I like questions like this, easy and lots of points, thanks!

I agree with the others, that without the mention of Britain in the question, the date is perfectly valid and option 1 should have been the correct answer.

Don Bernstein (12/22/2010)

---

SET IDENTITY_INSERT IDDemo OFF

EXEC ('SET IDENTITY_INSERT IDDemo ON')

INSERT IDDemo (pk_ID, Textdata) Values (4, 'This fails')

When I run it (sql2005), I get an error: Cannot insert explicit value for...