How to write stored procedure to update the data in 10
tables
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 are the steps to insert a table?
What is the use of nvl work?
What is scrollable cursor?
What is extended stored procedures?
What is a field name?
What is a db view?
Does a full backup include transaction log?
What is mscorsvw.exe - process - microsoft .net framework ngen?
How do I view a stored procedure in sql server?
How to select true false based on column value in sql server?
What command do we use to rename a database?
Tell me what is normalization? Explain different forms of normalization?
What is the purpose of a table?
What are Row versions of DataRow?
What is 4nf in normalization form?