What are the new features in SQL Server 2005?

3 Answers   Emphasis,

---

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  

---

What is the difference between coalesce() & isnull()?

0 Answers  

---

What do mean by xml datatype?

0 Answers  

---

What is a dbms wizard?

0 Answers  

---

---

how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,

---

What is the difference between varchar and nvarchar?

0 Answers  

---

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

---

How can we write or define DDL statements in Sql server and DML statements?

3 Answers  

---

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

---

What are the properties of the transactions?

0 Answers  

---

Is null in sql server?

0 Answers  

---