SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 728 Page Views: 

Which clauses are not supported by VIEW Creation Statement?



Posted By: Avi Date: 1 October 2010 12:26:08 PM
 Answer:

While creating a VIEW one can not use ORDER By,COMPUTE BY,COMPUTE clauses. Also INTO Keyword and temporary table reference is allowed.


Posted By: avibtech


Date: 1 October 2010 12:26:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image q7ahsz
Related Questions
SQL Server : What are the components of a Linked Server?

What are the components of a Linked Server?

Linked Server possess two main Components;- 1. An OLE DB Provider:- Is a DLL which manages and int....
Category: SQL Server Date: 10/1/2010 12:09:08 PM
SQL Server : What is a linked server?

What is a linked server?

Linked server is a server which allows remote access. It enables SQL Server to execute commands on r....
Category: SQL Server Date: 10/1/2010 12:08:08 PM
SQL Server : What is the purpose of SET NOCOUNT ON?

What is the purpose of SET NOCOUNT ON?

Whenever a Select Statement or any DML Statement is executed the server return a value that is the n....
Category: SQL Server Date: 10/1/2010 12:07:08 PM
SQL Server : What are distributed Queries?

What are distributed Queries?

Distributed Queries are the queries which can access multiple hetrogeneous data from different sourc....
Category: SQL Server Date: 10/1/2010 12:06:08 PM
SQL Server : When do the database checkpoints occur?

When do the database checkpoints occur?

Check point will occur in the following cases:- 1. It can be added manually . The Syntax is:- CHEC....
Category: SQL Server Date: 10/1/2010 12:05:08 PM