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.

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  

---

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

---

Do you know what is lock escalation?

0 Answers  

---

How to provide login information for a new odbc dsn?

0 Answers  

---

---

what is a schema in sql server 2005? : Sql server database administration

0 Answers  

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

how to rest identity columns in sql server

3 Answers   Matrix,

---

How to create a local temporary stored procedure?

0 Answers  

---

Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,

---

Explain indexed views?

0 Answers  

---

Why is DML provided?

1 Answers   Ernst Young, Thomson Reuters,

---