StoredProcedure
How to write insert,update,select in single storedProcedure
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Venkatesan JayakanthamPosted May 18, 2010, 2:01 PM
Check my blog for more sample,
http://venkattechnicalblog.blogspot.com/
Cheers,
Venkatesan Prabu .J
DRISHTYPosted May 18, 2010, 4:46 AM
Hi,
CREATE PROC USP_Test
AS
BEGIN
INSERT INTO Table1(ID,Name) VALUES(1,'Sam')
UPDATE Table1 SET Name='Sandy' WHERE ID=1
SELECT * FROM Table1
END