Answer / Ateequr Rehman

In MS SQL Server, you can use the OUTPUT clause to return the results of an INSERT, UPDATE, or DELETE statement. Alternatively, you can use stored procedures and output parameters.nnExample using OUTPUT:nINSERT INTO table_name (column1, column2) VALUES (@val1, @val2) OUTPUT INSERTED.ID

What is explicit cursors?

1 Answers  

---

What to check if a User database is locked?

1 Answers   TCS,

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1 Answers  

---

What is SQL server agent?

2 Answers   HCL, SAP Labs,

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

1 Answers  

---

What is use of except clause? How it differs from not in clause?

1 Answers  

---

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---

What are the advantages of using third-party tools?

1 Answers  

---

Explain active/passive and active/active cluster configurations?

1 Answers  

---

How do you troubleshoot errors in a SQL Server Agent Job?

1 Answers  

---

Is foreign key a primary key?

1 Answers  

---

What is normalization? Describe its different types.

1 Answers   Wipro,

---