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
Why variables called the most powerful component of ssis?
Can you explain what is indexed view? How to create it?
What happens if null values are involved in bitwise operations?
What is user-defined function?
How does recursive cte works in sql server?
Can you move the resources after pausing the node? : sql server database administration
Ms sql server index?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How to use “drop” keyword in sql server and give an example?
How do I trace a query in sql server?
What is an indexing strategy?
Can a rule be bound to any column of any data type?
How to check if a table is being used in sql server?
Is mysql better than sql server?
How can we determine what objects a user-defined function depends upon?