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 are trace flags and mention a few common trace flags used with sql server?

1087

---

In which tcp/ip port does sql server run? Can it be changed?

991

---

Can you explain important index characteristics?

992

---

What are the restrictions applicable while creating views? : SQL Server Architecture

1023

---

Explain optimistic and pessimistic concurrency?

993

---

What does it mean to invest in the index?

973

---

Write a SQL queries on Self Join and Inner Join.

1042

---

Write a program using SQL queries to find a unique entry in a table.

994

---

What is the use of =,==,=== operators?

1013

---

How the authentication mode can be changed?

1132

---

Explain comment on transactions?

996

---

How can I know what locks are running on which resource?

957

---

what are the important architecture components of SSRS?

140

---

Define inner join? Explain with an example?

996

---

What are cursors in ms sql server?

1179

---