If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

Where is trigger in sql server?

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

---

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

---

What is sql server 2000 work load governor?

0 Answers  

---

How do you debug a procedure in sql server?

0 Answers  

---

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

---

Explain what are commit and rollback in sql?

0 Answers  

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

What is the difference between varchar and nvarchar?

0 Answers  

---