Explain different types of locks in sql server.

0 Answers  

---

what is a self join? : Sql server database administration

0 Answers  

---

What is a trigger what are the advantages of trigger?

0 Answers  

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 Answers  

---

What is a virtual table in sql?

0 Answers  

---

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

---

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

---

How to use values from other tables in update statements in ms sql server?

0 Answers  

---

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

---

What is the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

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,

---