Answer Posted / mohan

Guys.. Why don;t you try for the Columns bided with User
Defined Data Type and try the above queries... and Also try
for the Auto incremented Columns..(Identity)....
Your opinion would change definately....
Try out...
I am sure it doesn't take account of UDT Binded Coulmns

Why we use trigger in sql server with example?

1014

---

When is the use of update_statistics command?

1059

---

How to drop an existing stored procedure in ms sql server?

1091

---

What are the advantages of stored procedure in sql server?

933

---

Explain what is row_number function?

1083

---

What are .mdf files?

1016

---

Should you normalize audio?

1008

---

Explain differentiate between a having clause and a where clause?

954

---

What is data source document?

1089

---

What is dbcc?

1181

---

Mention what are the core components of ssrs?

330

---

Write a SQL query in order to merge two different columns into single column?

1089

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2127

---

what's the difference between delete table and truncate table commands? : Sql server database administration

1041

---

List some case manipulation functions in sql?

1091

---