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

Explain the advantages of passport authentication.

0 Answers  


What is Web Application?

2 Answers   HCL,


What is the Difference B/W Finalize() and Dispose() in .Net?

12 Answers   HCL, IBM,


How to Insert a TextBox value in to Sql database using C# coding?

17 Answers   HCL, Sona, TCS,


What are triggers of an updatepanel?

0 Answers  


How to display validation messages in one control?

0 Answers  


What are the contents of cookie?

0 Answers  


Can I stream live content/events?

0 Answers  


Can asp.net work on an nt server?

0 Answers  


Is it possible to change the index of primary key on table?

0 Answers  


How do you store a value in viewstate and retrieve them?

0 Answers  


How you can access the values from the Repeater control in ASP.NET?

0 Answers  


Categories