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 |
What is the difference between a default skin and a named skin?
Explain difference between dataset and recordset?
What is strong-typing versus weak-typing?
Have you used microsoft dataaccess blocks and Exception blocks?
A web service can only be written in .net? State whether true or false.
How do you add a javascript function for a link button in a datagrid?
What benefit does your code receive if you decorate it with attributes demanding specific Security permissions?
What is event in asp.net?
For Web services where you can browse on the Internet?
What are url fragments?
When do you set "<IDENTITY impersonate="true" />" ?
How does a content page different from a master page?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)