Answer / Deepak Chandra

A Non-Clustered Index in SQL Server stores the actual data rows separately from the index and only includes a pointer to the location of each row. It can have multiple columns, but it does not physically sort the table's data based on the indexed columns.

Can a function call a stored procedure in sql server?

1 Answers  

---

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

1 Answers   HCL,

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1 Answers  

---

List all types of constraints in sql server?

1 Answers  

---

How many null values we can have in a unique key field in sql server?

1 Answers  

---

What do you mean by an execution plan? Why is it used?

1 Answers  

---

What are the different types of sub-queries?

1 Answers  

---