Answer Posted / aditya

select *from <table name>where sal<20

Difference between report and query parameter. Why do we need different type of parameter?

932

---

Explain left outer join and right outer join?

1013

---

How to defragment table indexes?

964

---

What are the differences between char and nchar in ms sql server?

1060

---

What is clr ddl trigger?

937

---

What is the difference between a unique key and primary key?

929

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1002

---

Explain Geometry datatype in sql server 2008 with example

956

---

What is difference between foreign key and unique key?

996

---

What is subreport?

141

---

What happens if strings are casted into wrong code pages in ms sql server?

1098

---

What is sql server schema compare? How we can compare two database schemas?

1007

---

How to return the second 5 rows in ms sql server?

1041

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

943

---

Explain the rules for designing files and file groups in sql server?

967

---