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



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 difference between a default skin and a named skin?

0 Answers   MindCracker,


Explain difference between dataset and recordset?

0 Answers  


What is strong-typing versus weak-typing?

0 Answers  


Have you used microsoft dataaccess blocks and Exception blocks?

1 Answers   Microsoft,


A web service can only be written in .net? State whether true or false.

0 Answers  


How do you add a javascript function for a link button in a datagrid?

2 Answers   Microsoft,


What benefit does your code receive if you decorate it with attributes demanding specific Security permissions?

2 Answers  


What is event in asp.net?

0 Answers  


For Web services where you can browse on the Internet?

1 Answers   Siebel,


What are url fragments?

0 Answers  


When do you set "<IDENTITY impersonate="true" />" ?

1 Answers  


How does a content page different from a master page?

0 Answers   MindCracker,


Categories