Explain Union, Intersect and Minus Commands
What are Union, Intersect and Minus?
Expert
Union:
It is the product of two or more tables.
Intersect:
It is the product of two tables listing merely the matching rows.
Minus:
It is the product of two tables listing simply the non-matching rows.
Explain about Character Functions.
Explain about the plan freezing in SQL server 2008.
Explain about a linked server?
Explain about the Sequences in SQL?
What are the new capabilities of SQL server 2008 for persisting BLOB data?
Illustrates the term Correlated Subquery?
Explain about the sparse columns of sql server 2008.
Create a procedure named BASKET_ADD_SP that accepts a product id, basket id, price, quantity, size code(1or2) and from code(3 or 4) and that uses this information to add a new item to the BB_BASKETITEM table.
Illustrates the JOIN commands?
Explain about Enhanced database mirroring in SQL server 2008.
18,76,764
1930603 Asked
3,689
Active Tutors
1450138
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!