What does truncate do?

0 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

What are orphan records?

0 Answers  

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

---

Can you insert NULL in unique column?

0 Answers   MCN Solutions,

---

---

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

Can you explain what are various ways to enhance the ssrs report?

0 Answers  

---

Which is better statement or preparedstatement?

0 Answers  

---

What is the difference between a function and a trigger?

0 Answers  

---

Explain what is meant by replication of database?

0 Answers   Cap Gemini,

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

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,

---