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 |
Can we store PROGID information in database and dynamically load the component ?
1 Answers Digital GlobalSoft, e4e,
What is query string with example?
how many databases and tables are uses in one project?
hi all; i need standard notes on .net(basics) for my seminar. im a starter in .net. plz suggest whr can i get satisfactory notes!!!
What is active web pages?
Below is a code extract from an ASP.Net application. The code basically reads data from the “name” field in the “members” table and prints them onto the webpage. Using the assumptions provided, fill in the 4 blanks below so that the code will run correctly. ‘Assumptions: ‘conn_str is a variable that holds the connection string to the database ‘Objects dbcomm and dbread are already declared earlier dbcomm = New OleDbCommand("SELECT name FROM members", conn_str) dbread = dbcomm._______________ _____________________ response.write(_______________) _____________________ dbread.Close()
Difference between connected architecture and Dissconnected architecture?
What is the postback property in asp.net?
1. What is the difference between Cache and Session? 2. I cache limited to page like viewstate or it's accessible through out the application like session? 3. Which one is better when I've some data that is to be used across the application? Why is to better than the other?
What is sdlc process?
Which is faster viewbag or viewdata?
What is server infrastructure?
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)