Write a sql query to display the current date?

0 Answers  

---

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

---

What are the different types of replication? How are they used?

3 Answers  

---

What is row_number () and partition by in sql server?

0 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

---

---

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

---

What are distinctive joins find as a part of sql?

0 Answers  

---

What is the difference between count and distinct count?

0 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

What is left outer join in sql server joins?

0 Answers  

---

What is dirty page?

0 Answers  

---

How can you find out which stored procedures are recompiling?

0 Answers  

---