Stored procedure for retrieving and update existing records
Hi, I am doing a update stored procedure that allows me to retrieve and update exisiting records from database. However, records entered previously cannot be retreived, hence unable to update it.
This is the code for it:
Re: Stored procedure for retrieving and update existing records
If u retrieve the previously entered records use the
SELECT IDENT_CURRENT(‘table name’)
is used the last inserted record id value from particular table.After that u can update the particular record with new values.
|All times are GMT +5.5. The time now is 01:18.|