Answer Posted / harinireddy
view is a virtual table created from the physical table
which is existing.view can be updated unless the base table
does not have any relation u another table
| Is This Answer Correct ? | 14 Yes | 4 No |
Post New Answer View All Answers
Write the SQL query to drop, truncate and delete table.
what information is maintained within the msdb database? : Sql server administration
What are dml (data manipulation language) statements in ms sql server?
How to test a dml trigger in ms sql server?
what is denormalization? : Sql server database administration
Equi join and non equi join is possible with sql server?
what are different types of backups available in sql server? : Sql server database administration
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Explain different backup plans?
How to concatenate two binary strings together?
What is the difference between having clause and where clause in sql server?
What is the use of floor function in sql server?
What is the difference between for xml raw and for xml auto?
What are the common performance issues in sql server?
How can you find out how many rows returned in a cursor?