Interested to Buy Any Domain ? << Click Here >> for more details...
How to write stored procedure to update the data in 10
tables
- 4 Answers
- 13965 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
How to enforce security in sql server? : sql server security
Are all views updatable ?
What is conditional split?
Explain stored procedure?
How do I create a trace in sql server?
What is RMS migrations?
Explain the functionalities that views support?
What is read committed?
How can you find out which stored procedures are recompiling?
what is bit datatype? : Sql server database administration
Do you know what is normalization of database? What are its benefits?
What is sub-query in sql server?
How do I find sql server instance name?
Explain about extended stored procedure?
Explain the rules for designing files and file groups in sql server?
