How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

We need to perform what steps in the following order to work with a cursor?

0 Answers  

---

What is a performance monitor?

0 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

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,

---

---

What command do we use to rename a db, a table and a column?

0 Answers  

---

What are cursors stored procedures and triggers?

0 Answers  

---

How to create a store procedure with encryption?

0 Answers  

---

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

---

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

---