Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / darshan shah
View is sub set of one or more then one tables
View is use to fetch the selected columns from one more
then one tables.
Yes we can update the view if it is not read only.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a schema in ms sql server 2005?
what is denormalization and when would you go for it? : Sql server database administration
Explain a join?
When cursors are useful?
What is tcl in sql server?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Do you know sql server 2008 backup compression?
Is the order of columns in the set clause important in ms sql server?
Are resultset updatable?
How to retrieve error messages using mssql_get_last_message()?
What is SQL Azure Federations?
How do you drop an index?
What is partition in sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
