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

What is the use of The Page.Master Property?

1 Answers  


How can you handle errors in Web API?

0 Answers  


Can you explain how ASP.NET application life cycle and page life cycle events fire?

0 Answers   MindCracker,


Usage of web.configuration ?

3 Answers   Microsoft,


what is uncle aunty file

1 Answers  






What is the difference between and ActiveX dll and control ?

1 Answers   Microsoft,


How can u debug your .net application?

0 Answers  


Can you dynamically assign a Master Page?

0 Answers   MCN Solutions,


Define dll hell?

0 Answers  


Is a dll file an executable?

0 Answers  


What combination of methods are used to improve the speed of the fill() method of the DataAdapter? a) BeginFillData() and EndFillData() b) StartFillData() and EndFillData() c) BeginLoadData() and EndLoadData() d) StartLoadData() and EndLoadData()

2 Answers   Syntax Softtech, winfoware,


Who will magage un-managed code?

7 Answers   HP,


Categories