What is difference between views and stored procedures?

0 Answers  

---

Explain having clause and where clause?

0 Answers  

---

explain different types of joins? : Sql server database administration

0 Answers  

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

How to get nth highest salary from employee table.

0 Answers  

---

What are the advantages of having an index on the sql server?

0 Answers  

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

---

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

What are the aggregate and scalar functions?

0 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

Explain for xml explicit mode?

0 Answers  

---