Limits applicable for creating views
What are the limits applicable when creating views?
Expert
The limits applicable while creating views are as follows:
• Views can be created by referencing tables and views simply into the current database.
• A view name should not be similar as any table owned by such user.
• You can build views upon other views and upon procedures which reference views.
• Rules or DEFAULT descriptions can't be associated along with views.
• Only INSTEAD OF triggering can be related with views.
• The query which defines the view cannot contain the COMPUTE or COMPUTE BY or say ORDER BY clauses or the INTO keyword.
• You can’t describe full-text index definitions for views, can’t create temporary views and can’t create views upon temporary tables.
Illustrates the policy based administration feature of SQL Server 2008?
What are the differences between a primary key and a unique key?
Define the term Posting in database.
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.
How would you enter Characters as HEX Numbers?
Define the Isolation Levels.
Explain advantages of MyISAM over InnoDB?
Illustrates the JOIN commands?
Explain about the Entity Data Services within sql server 2008.
18,76,764
1949545 Asked
3,689
Active Tutors
1433171
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!