What are different types of constraints?

0 Answers  

---

How to get the definition of a stored procedure back?

0 Answers  

---

Explain the creation and execution of a user-defined function in the sql server?

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

---

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

Can two tables share the same primary key?

0 Answers  

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

What is an indice?

0 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---