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.

Tell me what is a linked server?

0 Answers  

---

Explain what is use of dbcc commands?

0 Answers  

---

What is the difference between upgrade and migration in sql server?

0 Answers  

---

What are the restrictions while creating batches in sql server?

0 Answers  

---

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

What is SQL Profiler and the use of it?

2 Answers   247Customer,

---

How do I port a number to sql server?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

---

List all types of constraints in sql server?

0 Answers  

---

What is a function? Give some example?

3 Answers  

---

What is the difference between for trigger and after trigger?

0 Answers  

---

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

---