Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

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  

---

Differnce between sel server 2000 and 2005

3 Answers  

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

in how many ways we can use count()

2 Answers  

---

Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

---

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---

Does partitioning improve performance sql server?

0 Answers  

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---