Answer Posted / sandip gele
In view,we can create virtual table with the columns from
different tables by relation between them, we can use this
view as a table for selecting a data but we can't use view
to insert data.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we write trigger for view?
what is the primary use of the model database? : Sql server administration
Explain some stored procedure creating best practices or guidelines?
What is table valued function and scalar valued functions?
Do you know query execution plan?
What are null values in ms sql server?
What are the steps you must follow to hide sql server instances?
Can truncate be rolled back?
What is acid mean in sql server?
Write a code to select distinct records without using the DISTINCT keyword.
Tell me about joins in database system and explain each in detail.
How you can get a list of all the table constraints in a database? : Sql server administration
What is snapshot replication?
What are views in ms sql server?
Write a sql query to sort on different column name according to the parameters passed in the function?