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.

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

---

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

---

How to count the number of duplicate items in a table?

3 Answers  

---

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

---

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

---

What is the stored procedure?

0 Answers  

---

What are the differences between clustered and non-clustered index?

0 Answers  

---

What is apply operator in sql?

0 Answers  

---

Can sql servers link to other servers like oracle?

0 Answers  

---

How to find tables without indexes?

0 Answers  

---