Interested to Buy Any Domain ? << Click Here >> for more details...
How to write stored procedure to update the data in 10
tables
- 4 Answers
- 13828 Views
- I also Faced
- E-Mail Answers
Answer Posted / jaipal
CREATE PROCEDURE <<procName>>
(
@param1 varchar(20),
@param2 varchar(20)
)
AS
UPDATE <<tableName1>> SET <<colName1>> = @param1 WHERE
<<colName2>> = @param2
UPDATE <<tableName1>> SET <<colName1>> = @param1 WHERE
<<colName2>> = @param2
..
..
..
..
UPDATE <<tableNameN>> SET <<colName1>> = @param1 WHERE
<<colName2>> = @param2
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
What is a recursive stored procedure in sql server?
How to make a remote connection in a database?
Do you have any idea about the tcl commands?
How to find the source of a table in sql server?
What is RAID? What are the different types of RAID configurations?
What is the recovery model? List the types of recovery model available in sql server?
What is SQL Azure Fabric?
explain databases and sql server databases architecture? : Sql server database administration
Do you know the different ddl commands in sql?
How to create user defined functions with parameters?
Can you explain important index characteristics?
What is the difference between for xml raw and for xml auto?
What does asynchronous call backs means?
Tell me about normalization in DBMS.
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
