Post reply

how to set flag for one table?

  • April 10, 2008 at 10:44 pm

    #189089

    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:

  • April 10, 2008 at 11:19 pm

    #801280

    [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]

    MH-09-AM-8694

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply