Execute multiple statement in SQL procedure

Question

How to I write and execute multiple statement in SQL procedure.

Vijay Yadav · Answer

Resolved?

Akkiraju Ivaturi · Answer

CREATE PROCEDURE PROCEDURENAME PARAMETERS AS BEGIN SELECT * FROM ABC SELECT * FROM DEF UPDATE TABLE TABLENAME SET .... INSERT INTO .... DELETE FROM ... :::: ::: ::: ::: ::: ANY NUMBER OF STATEMENTS CAN BE ADDED END If this is not your question let me know and ask in precise what do you want to accomplish. That may help me to give you more clear answer.