Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / samy
Union:
combine two tables and common values to be retrieved no
duplicate values
Union All:
All the values to be retrieved when combine two table.
(duplicate values)
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is an indice?
What does indexation mean?
How to execute stored procedure and set temp table in sql server?
Mention the different types of triggers?
What is meant by referential integrity?
What is data file in computer?
Determine when to use stored procedure to complete sql server tasks?
Do you know what is sql service broker?
When do you think a developer should use sql server-based cursors?
How do indexes help, types?
How do you size a resultset?
How to create dbo table in sql server?
How to create a dml trigger using create trigger statements?
Explain about temporary stored procedure?
