sql stored procedure

[harithadotnet]

HI How to use insert and update query in a single stored procedure if u know plz let me know too Thanks in advance

Haritha

[Krish KP]

what exactly you are looking for procedure can be created with both insert & update statements one after other.

Regards KP

[N a v a n e e t h]

Hi You can write any queries in stored procedures. Your procedure could be some thing like this

CREATE PROCEDURE InsertUpdateProcedure
AS

INSERT INTO TABLE VALUES(VALUE)

UPDATE TABLE SET COLUMN = VALUE WHERE CONDITION

GO

First insertion will be done and after that updation Happy Programming

---

My Website | Ask smart questions