You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

---

How to create a local temporary stored procedure?

0 Answers  

---

Name the different type of indexes in sql?

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

How self join is different from outer join?

0 Answers   Blue Star,

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

How to genrate automaticlly empid like gt001

4 Answers  

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

How to provide Security for package?

1 Answers   Convergys,

---

What are the different types of replication are there in sql server 2000?

0 Answers  

---

Which tcp/ip port does the sql server run on? How can it be changed?

0 Answers  

---