Is foreign key a primary key?

0 Answers  

---

What happens to a trigger with multiple affected rows?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

---

What do you mean by data manipulation language?

0 Answers  

---

---

Define magic tables in sql server?

0 Answers  

---

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

---

What are the restraints imposed on the table design by a merge replication?

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

Explain unique key in sql server?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

What is the process of normalization?

0 Answers  

---