Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

---

How to find the second highest salary of an employee?

0 Answers  

---

What is lock escalation?

1 Answers  

---

How to create new databases with "create database" statements?

0 Answers  

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

How to stop a loop early with break statements in ms sql server?

0 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---

Define primary key?

0 Answers  

---

How to create a large table with random data for index testing in ms sql server?

0 Answers  

---

What do you understand by a stored procedure?

0 Answers  

---