[font="Verdana"]
dhanuhere (4/10/2008)
Hi all,I am not great in sqlserver i am bascicaly asp.net professional.
I want to set a column as flag for indicating user edit data time .somAeone suggest me set isEdit column as boolean but i cannt find any datatype like this.
can you plz suggest me wat i ll do?:unsure:
From BOL
Transact-SQL Reference (SQL Server 2000)
Bit:- Integer data type 1, 0, or NULL.
so here you can store only 1 or 0. 1 for False and 0 for True. So isEdit column should have Bit datatype.
for more information on SQL Server Data Types and their equivalents in .Net, refer
http://msdn2.microsoft.com/en-us/library/ms131092.aspx
Confirm on this.
Mahesh
[/font]