Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

---

what is the difference between openrowset and openquery?

0 Answers  

---

What is an execution plan?

0 Answers  

---

What is purpose of normalization?

0 Answers  

---

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

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

Do you know what is difference between stored procedure and user defined function?

0 Answers  

---

Explain the architecture of ms sql reporting service?

0 Answers  

---

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---

Give an example of SQL injection attack ?

0 Answers   HAL,

---