List out the difference between union and union all in sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is the datatype of rowid?

0 Answers  


Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  


Can a table be moved to different filegroup?

0 Answers  


What is subquery explain with example?

0 Answers  


What are the advantages of paper records?

0 Answers  






What is bcnf normalization form?

0 Answers  


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


How to list all columns in a table using odbc_columns()?

0 Answers  


can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  


What is index, cluster index and nonclustered index?

0 Answers  


What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  


Categories