What do you mean by sql server 2005 express management tools?

0 Answers  

---

To find second largest salary in Employee table

17 Answers   CSS,

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

Differentiate between a having clause and a where clause.

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

Can we do dml on views?

0 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---

How to join two tables in a single query in ms sql server?

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  

---

How do I find query history in sql server?

0 Answers  

---