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
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What are the encryption mechanisms in sql server?
What is the difference between char and varchar2 datatype in sql?
What is the process of normalization?
What is the difference between varchar and nvarchar datatypes?
What are the types of ssrs?
How to sort query output in descending order in ms sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to drop an existing user defined function in ms sql server?
Explain active/passive and active/active cluster configurations?
How many null values we can have in a unique key field in sql server?
What are the requirements for sql server 2016?
What is a not null constraint?
what protocol both networks use? : Sql server database administration
Explain indexed views and partitioned view with their syntax.