Answer Posted / pandian

select top 1 salary from (select distinct top 9 salary from
EmpMaster order by salary desc)a

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

993

---

How to create a simple stored procedure in ms sql server?

1035

---

How to find out what is the default collation in a database?

1125

---

what kind of lan types do you know? : Sql server database administration

982

---

What is 3nf normalization?

1004

---

Is there any difference between the primary key and unique key?

1006

---

What is a trigger? Why we need it?

1003

---

What is the significance of null value and why should we avoid permitting null values?

992

---

What is the syntax to execute the sys.dm_db_missing_index_details?

1030

---

Define left outer join?

974

---

If we delete pack Spec what will be the status of pack Body ?

1478

---

How can I check if a view exists in a sql server database?

1042

---

Explain Capacity planning to create a database? and how to monitor it?

4207

---

Does view occupy space?

950

---

What is the purpose of update statistics and scope_identity() function?

1100

---