I am using stored procedure to return the identity column value in a table against the row in which some vlaues are inserted. for example using stored procedure if we insert data in a table:
Table tblUser
UserID integer, identity, auto-incremented
Name varchar
UserName varchar
Password varchar
So if I run the store procedure inserting some values in the table tblUser like,
INSERT INTO tblUser(Name, UserName, Password) VALUES ('example', 'example', 'example')
how can I return the value of UserID of the row at which this insertion will take place. I need The value of UserID for some other operations, can anybody solve this?
Views:
8756
Total Answered:
1
Total Marked As Answer:
0
Posted On:
18-May-2016 02:46