how to update data using store procedure

Answer Posted / sathish

create procedure <pro.name>
{
@variable declartion,,,,,
AS
if exist(select the table with condition)
BEGIN

update query

END

else

BEGIN
//insert new data
END

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How should I destroy my objects in asp.net?

794


What is the difference between equals() and == in c#?

757


What is Web Server Control Templates.?

791


Tell me how asp.net mvc differs from asp.net web forms? : asp.net mvc

814


Explain managed code an un-managed code.

780


Can we have multiple web config files for an asp.net application?

728


What is new asp.net core?

779


What are session state modes? List some of the important session state modes of asp.net.

721


What is protected configuration?

846


What are the different validators in asp.net?

763


What is a multilingual website?

769


What is directive in asp net?

753


What is session authentication?

734


What is css in asp.net?

780


Whats the difference between abstract factory pattern and factory pattern?

814