Hi,can some one tell me how to write a stored procedure in sql to set deleted to 1 for the table name Account , where the column names are
account id(pk, char(10),not null),
account name varchar(20,not null),
is default (bit,not null),
deleted(bit,not null)