how to update data using store procedure



how to update data using store procedure..

Answer / 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

More ASP.NET Interview Questions

Describe in brief .net framework and its components.

0 Answers  


why should i use FormsAuthentication.RedirectFromLoginPage (); Method in Form Authentication?Without using this method also it's good??

2 Answers  


how can we maintain security in soted procedure?

1 Answers  


What is the main difference between grid layout and flow layout?

1 Answers  


Types of values mode can hold session state in web.config ?

1 Answers   Accenture, Parrot Systems,






What are resource file and how do we generate resource file?

0 Answers  


Is it possible to prevent a browser from caching an ASPX page?

3 Answers  


how we deploy the asp.net 2.0 application

2 Answers   Logistics,


In early binding will the method invoked on com component will verify it?s existance in the system or not ?

0 Answers   DELL,


What is the difference between login controls and forms authentication?

0 Answers  


Explain diff between dataset and datareader?

0 Answers  


Explain what a diffgram is, and a good use for one?

2 Answers  


Categories