What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---

Can sql servers linked to other servers?

0 Answers  

---

Name few of the dcl commands in sql?

0 Answers  

---

How can we determine what objects a user-defined function depends upon?

0 Answers  

---

To find second largest salary in Employee table

17 Answers   CSS,

---

---

What is a join and their types?

2 Answers   Challenger Financial,

---

What is the recovery model?

0 Answers  

---

How is foreign key related to primary key?

0 Answers  

---

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

---

What is a ddl statement?

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 is the difference between osql and query analyzer?

0 Answers  

---