Mention a few common trace flags used with sql server?

0 Answers  

---

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

---

How many types of subqueries are there in sql server?

0 Answers  

---

What is transaction server implicit?

0 Answers  

---

What is repeatable read?

0 Answers  

---

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

What is ddl and dml commands?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

What is named query? : sql server analysis services, ssas

0 Answers  

---

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---