Thursday, February 11, 2010

BIT data type

Do you remember BIT data type?
What will be the value of the @Bit variables in the following?

DECLARE @Bit BIT
SET @Bit = -1

A. 0
B. -1
C. 1
D. An error will be encountered. Only 1, 0 and NULL values are allowed for a bit data type.

Answer:[C]
Highlight to find out the answer.

No comments:

Post a Comment