What is sub-query in sql server? Explain its properties.

0 Answers  

---

how do u find least salary in a table

4 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

what is a transaction? : Sql server database administration

0 Answers  

---

---

How to include date and time values in sql statements?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

What are the advantages of using a stored procedure?

0 Answers  

---

What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---