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.

Why main is user defined function?

0 Answers  

---

What are the differences between user defined functions and stored procedures?

0 Answers  

---

What is indexed view?

0 Answers  

---

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

---

How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

1 Answers   INDUS,

---

How to delete a login name in ms sql server?

0 Answers  

---

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,

---

What are “lost updates”?

0 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

user defined datatypes

1 Answers   Wipro,

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---