Hi I create a table in asp.net I want to store Id into database by default id is a primary key Column in database and I also create order by procedure what I do on every insertion Id automatically changed For Eg I insert data this time id is 1 and 2nd time id 2 the user cant see her id . and I dont want to use AutoIncrement In Sql
declare @Id bigint Set @Id= select cast(isnull(max(Id),0) as bigint)+1 from table insert into table(ID) values(Id)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)