what is the purpose of creating view is sql server 2000
Answers were Sorted based on User's Feedback
Answer / satyanarayana
Some times we need to use the same query repeatedly for a
large number of times.So instead of writing the same query
all the times we use views. Means we store the query with a
name that name is called as a view.
| Is This Answer Correct ? | 4 Yes | 7 No |
Answer / anil sharma
Views are dynamic table that is it created at run time and
not stored on server database.
by using view we can solve typical query.
| Is This Answer Correct ? | 1 Yes | 4 No |
What are the basic features of a trigger in ms sql server?
what changed between the previous version of sql server and the current version? : Sql server database administration
Can you have a nested transaction?
What is sub query and its properties?
What the different components in replication and what is their use?
Explain about unique identifier data type in sql server?
What is the difference between cross join and Full outer join?
What are the recovery models in sql server 2000?
Explain comment on transactions?
I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.
Define outer join?
How can we write or define DDL statements in Sql server and DML statements?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)