Answer Posted / Dinesh Rawat
In SQL Server, a View is a virtual table based on the result-set of an SQL statement, whereas a DDL (Data Definition Language) object (such as Table, Index, or Stored Procedure) is called a Schema Object. The main differences between views and Dip (Database Infrastructure Program) are:
1. A View does not exist as a separate entity in the database but provides an alternative way of querying data. Dip, on the other hand, is a tool used for creating and managing various aspects of a database.
2. A View is read-only unless it contains a SELECT INTO statement or is created using UNION ALL.
3. Dip is not a concept in SQL Server but is a tool provided by Microsoft for managing the Sybase database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What kind of problems occurs if we do not implement proper locking strategy?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is sql server query analyzer?
What is a coalesce function?
What are the properties of the transaction?
What is clustered index
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What are the different types of subquery?
What are wait types?
What are different types of constraints?
What is normalization and what are the advantages of it?
How to connect php with different port numbers?
Can we do dml on views?
What is acid mean 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?
