Answer Posted / bharathi

Answer is deleted and inserted

INSERT Trigger populates inserted table
DELETE Trigger populates deleted table
UPDATE Trigger poulates both inserted and deleted tables

how we use window authentication connection with sql server.?

1206

---

What is a db view?

946

---

Can an entity have two primary keys?

1027

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2407

---

What are binary string data types in ms sql server?

1379

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1027

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

944

---

What's new in sql management studio for sql server? : sql server management studio

1116

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

---

Explain what is public role in sql server?

1183

---

Explain about protocol layer present in SQL server?

1287

---

What is a functions and types in sql server?

1141

---

Can binary strings be used in arithmetical operations?

983

---

What is data block and how to define data block size?

1076

---

what is a sub-report?

146

---