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 a self join? : Sql server database administration

0 Answers  

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

How do I shrink an ldf file?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

How to change a login name in ms sql server?

0 Answers  

---

What is compression - row-level and page-level compression?

0 Answers  

---

What does this statement do @@rowcount?

0 Answers  

---

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

---

How to display a past time in days, hours and minutes?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---