Answer / saravakumar

UNION RULES
A UNION must be composed of two or more SELECT statements,
each separated by the keyword UNION.
Each query in a UNION must contain the same columns,
expressions, or aggregate functions, and they must be listed
in the same order.
Column datatypes must be compatible: They need not be the
same exact same type, but they must be of a type that SQL
Server can implicitly convert.

What is transcation?Plz give One example?

2 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 are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

Difference between aggregate functions of sql?

0 Answers   EXL,

---

What are locks in sql?

0 Answers  

---

how to know Who Is Blocking Your SQL Server?

4 Answers  

---

What is the importance of concurrency control?

0 Answers  

---

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

---

Can we linked SharePoint to a SQL database?

0 Answers   Sans Pareil IT Services,

---

What are the transaction properties?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

---