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

What are cao and sao.

542


What is a postback url?

491


What is the difference between custom controls and user controls?

473


What is the use of the tag in the web.config file?

569


Explain Features in ASP.NET

572






What is cookies in asp net?

518


Explain login control and form authentication.

557


What is bson in web api?

585


Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?

1715


Explain the difference between web user control and web custom control?

532


Explain how is a property designated as read-only?

549


What are the differences between the response.write() and response.output.write()?

529


What is marshalling ? Is it a part of asp.net ?

614


Where the cookie value is stored?

507


What is a SESSION and APPLICATION object?

574