COUNT THEN UPDATE ELSE INSERT CREATE PROCEDURE / CURSOR

Question

How to Button1_Click Count and if (count) ==0 EXISTS update query than (count) ==1 update else insert asp .net

Jignesh Trivedi · Answer

hi I think this can be achieve with in store procedure.... like create procedure tes ( @id int ) AS begin if(EXISTS(select * from table1 where ID = @id) begin -- write you update table statement here end else begin -- write you insert table statement here end end hope this will help you.

Jaganathan Bantheswaran · Answer

Hi Please give us some more details.