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 are the properties of primary key?
Call by value and call by reference in procedure and function, with NOCOPY.
How to fine-tune reports?
What are joins in sql and what are the different types of joins?
What is primary key, unique key, and foreign key?
What are the different types of backups that exist?
How to connect ms access to sql servers through odbc?
Explain the difference between function and stored procedure?
Explain the functionalities that views support?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
how to avoid cursors? : Sql server database administration
How to list all tables in the database using odbc_tables()?
What is transactional replication?