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

What is the default port for SQL Server over a firewall?

1030

---

Can we delete data from a view?

881

---

What does dml stand for?

905

---

What is rolap and its advantage? : sql server analysis services, ssas

1219

---

What are the Advantages of using CTE in sql server?

1041

---

How do you open a cluster administrator?

1002

---

Is port 1433 secure?

931

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

913

---

Does group by sort data?

846

---

When should you use an instead of trigger?

918

---

Explain syntax for viewing trigger?

885

---

What is used to replicate sessions between instances in coldfusion clusters?

1016

---

Where are stored procedures in sql server?

1007

---

What is isnull() operator?

976

---

How to connect to a sql server using odbc_connect()?

1094

---