Answer Posted / anilreddy

select count(distinct(columnname)) from tablename

What language is sql server written in?

1012

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

985

---

What are data files?

1024

---

Tell me about joins in database system and explain each in detail.

1031

---

Can you explain what is sql server english query?

980

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1987

---

Can we call stored procedure in view in sql server?

889

---

What is triggers and its types?

995

---

What is the use of custom fields in report?

983

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1041

---

What is subreport?

141

---

Explain the dbcc pintable command when would you use it?

893

---

Does sql server 2000 full-text search support clustering?

847

---

Explain data warehousing in sql server?

1025

---

Can a table have 2 foreign keys?

888

---