for bit datatype, any value which in non-zero is converted to bit 1.

try this you will get better understading,

declare @bit bit

set @bit = -0

select @bit

declare @bit bit

set @bit =...

tried on sqlserver 2000,2005, 2008.. result obtained from query in (1,1)..

Can anyone explain regarding output... 0 ,1...???

If you just want to transform rows into column to show in Cross-Tab report, there is an alternate way.

Use Cross-Tab report to achieve this.

hey...

First create SQL login... then grant permission to that record... use below query.

GRANT SELECT ON (YOUR table Name ) TO (YOUR sql login name).

it allow only reading of...

Use below query ..

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME = (Your column name..)

Hope this will help you..

LOL 🙂

Yes i am Using SSMS....

Thanks for you support.

While running query in above link i got following error.

As i do not have administrator permission, can i still import data to excel sheet.

Msg 15281, Level 16, State 1, Line...