Answer Posted / amit

select distinct * from table_name

What is update locks?

887

---

How to round a numeric value to a specific precision?

1075

---

Difference between group by clause and having clause in SQL?

971

---

What part does database design plays a role in performance of an sql server-based application?

983

---

What are cursors stored procedures and triggers?

1021

---

How many databases instances are there in sql server 2000?

1098

---

What is table value parameters (tvp)?

1101

---

What are the parts of a function?

942

---

What is the report model project?

141

---

Is candidate a key?

947

---

How do I start sql server?

974

---

Where do you find the default Index fill factor and how to change it?

1063

---

What happens when transaction log is full?

927

---

What are secondary xml indexes?

1026

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1022

---