What Are Three Rules to Use UNION IN SQL SERVER
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.
Is This Answer Correct ? | 7 Yes | 0 No |
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
What is a database in ms sql server?
How many columns can we include on clustered index ?
How many levels of sp nesting are possible?
What is transactional replication?
What is a livelock?
What is difference between standardization and normalization?
How network traffic be reduced by using the stored procedure?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
How to find the source of a table in sql server?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it