Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 is the difference between viewstate and hidden field in asp.net?

1001


What is the file through which you can customize your asp.net application?

1053


Explain server side state management system.

920


What is odata in web api?

1036


What are the session management techniques asp net?

957


What are the different validators in asp.net?

963


What is content page in asp net?

915


What is preprocessor in .net? Where it use?

945


What is bound controls

1011


How can we update records in gridview?Is there any appropriate code for it?

2106


How can you use a custom controls in ASP.NET application?

966


Explain asp.net mvc request life cycle? : asp.net mvc

995


Explain what is an abstract class?

976


Mention the execution process for managed code?

946


Explain one critical mapping?

952