Answer Posted / mohit johri

Hey Vaishaili,
The query you wrote first of all does not require a dynamic
string to be constructed and then executed. The problem
with this is you are defeating the purpose of a stored
procedure.

A stored procedure is basically used to make the execution
faster as the code is kept in pre-complied mode.

Here what you are doing is you are giving an 'EXEC'
statement to execute the query which means that
the 'update'statements are not kept in pre-compiled mode.
They will first compile and then execute just like a normal
SQL statement.

Hence you should directly write the 'UPDATE' statements so
that it should only be executed and not compiled as they
are already kept in a pre-compiled mode.

The procedure can be best written as follows:

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



Exec(@sql)

Is a primary key unique?

991

---

Explain about analysis services?

1049

---

Define tempdb database?

996

---

What is difference between primary key and foreign key?

904

---

Define self join in sql server joins?

950

---

Explain the steps to create and execute a user-defined function in the sql server?

967

---

What is bcnf normalization form?

1114

---

What is nonclustered index on computed columns?

960

---

What is indexing in sql server with example?

1002

---

What is the difference between stored procedure and functions?

1134

---

What are data files?

1041

---

What are examples of triggers?

1088

---

How does using a separate hard drive for several database objects improves performance right away?

932

---

List the different normalization forms?

980

---

How to return the top 5 rows from a select query in ms sql server?

1138

---