Flag in SQL

[Limno]

Hi,

Is there any Flag function in SQL Server. I want to set Flag=1 at 1st time entry. if i change that value or edit its value same record values, it's value should become 2.
I dont Know whether itz front end work or SQL holds any Flag function. So, can any one suggest me.

Thanks in Advance.

[debasisdas]

You need to add an additional field to database and keep that updating as per your requirment.

[Limno]

You need to add an additional field to database and keep that updating as per your requirment.

Thanks for replying me,

Can u give me more explanation to this. yes i m hving one field has Flag. But i dont know hw to do this.

Can u explain me with Query Example. Please.

Limno

[debasisdas]

You need to write a trigger for the purpose.

[ck9663]

1. Create a field on your table for this flag.

2. Set the default value of this field to 1.

3. Create a trigger that will handle the replace of the value for this field for every update or delete.

-- CK