Answer Posted / Nikhil Kumar
A view is a virtual table based on the result-set of an SQL statement. It does not store data, but instead contains the SQL code to compute the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List the ways in which dynamic sql can be executed?
What are the kinds of subquery?
Why and when do stored procedure recompile?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain system functions or built-in functions? What are different types of system functions?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Can we do dml on views?
Why should you use or avoid select * statements?
What is acid mean in sql server?
what is spatial nonclustered index
What are wait types?
What is the difference between upgrade and migration in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to enter binary string literals in ms sql server?
