what is the purpose of creating view is sql server 2000
- 13 Answers
- 19347 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / parmanand
Not all the views are updatable. updatable viwes are
available from SQL Sever 2000 version.
Pls remember all the views are not up datable again.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
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?
What is normalization according to you and explain its different levels?
What is the purpose of the model database?
What is difference between views and stored procedures?
What are wait types?
How to add additional conditions in SQL?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
How to delete a database in ms sql server?
What is a print index?
what is the system function to get the current user's user id? : Sql server database administration
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is the order in which the sql query is executed?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What happens if null values are involved in arithmetic operations?
