What is sqlservr.exe - process - sql server (sqlex?press)?

0 Answers  

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---

Explain partitioned view?

0 Answers  

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

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,

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

How do I find information about the install locations for the various instances running on a computer?

0 Answers  

---

What is proper subset of candidate key?

0 Answers  

---

check, not null,unique

2 Answers   IBM,

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

Explain what are the different index configurations a table can have?

0 Answers  

---