Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

How to generate create function script on an existing function?

0 Answers  

---

Explain boyce and codd normal form(bcnf)?

0 Answers  

---

What is the benefit of normalization?

0 Answers  

---

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

What is the data type of time?

0 Answers  

---

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

---

how many type of subquery?

2 Answers  

---

What the difference between UNION and UNIONALL?

0 Answers   HCL,

---

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  

---