Answer / Shambhu Kumar

By default, GROUP BY does not sort data. If you want your data sorted after being grouped, you should use the ORDER BY clause.

Explain about the command-line tool SQLCMD?

1 Answers  

---

What is a trigger what are the advantages of trigger?

1 Answers  

---

How can you stop stored procedures from recompiling?

1 Answers  

---

What is left outer join in sql server joins?

1 Answers  

---

Explain relational data?

1 Answers  

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

How do you connect 100 files as a flat file sources in one package of SSIS?

2 Answers  

---

How to write a query with a right outer join in ms sql server?

1 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

how insert selected column only ?

3 Answers   Robert Half,

---

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?

1 Answers  

---

How to implement service broker?

1 Answers  

---