Click here to Skip to main content
15,920,111 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Step1: I have a table with identity(1,1) [RoleID] and [Description]
Step2: I have created storedprocedure to insert record that has inserted 5 records that is fine.
Step3: While insert the record no need to give RileID because that is identity column automatically inserted.
Step4: Here is my question
1 I have to rollback (Delete recent record which is RoleID =5)
2 That has deleted fine
3 If i want to insert record again that record should be have RoleID 5 which is already inserted and deleted from that table.
4 how to do this in sql server.
Posted

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900