Answer Posted / ramesh raja
UNION: combine distinct values between two tables
UNION ALL : combine all values and also duplicates values
between the two tables
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Does index slows down insert statements?
Which database stores information about replication?
How to enter date and time literals in ms sql server?
What are logical/boolean operations in ms sql server?
Why transaction is important?
Why people hate cursor?
What happens if null values are involved in datetime operations?
Explain contrast amongst grouped and non-bunched records?
What are the dmvs?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Explain system views?
Explain what is lock escalation and what is its purpose?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to create a user to access a database in ms sql server using "create user" statements?