What is the stuff and how does it differ from the replace function?

0 Answers  

---

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

---

How do you rebuild an identity column?

0 Answers  

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

---

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

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

how can a database be repaired? : Sql server administration

0 Answers  

---