[Message Deleted]
Visual Basic
2
Posts
2
Posters
0
Views
1
Watching
-
[Message Deleted]
-
[Message Deleted]
Use a stored procedure and have it find you the max value of the primary key column and add 1 to it and then insert the record using the new value. Declare @NextID int; Select @NextID=(case when Max(ID) is null then 1 else Max(ID)+1 end) From Table1 Insert Into Tablel (TStamp,ID,...) values (GetDate(),@NextID,...)