Author Topic: Q What are the restrictions on views in SQL?  (Read 104 times)

0 Members and 1 Guest are viewing this topic.

Offline rpmolecule

  • Full Member
  • *
  • Posts: 231
  • Karma: +1/-0
  • Seize the Day!
    • View Profile
Q What are the restrictions on views in SQL?
« on: January 06, 2009, 07:17:19 AM »
Q What are the restrictions on views?
The ORDER BY, COMPUTE or COMPUTE BY, and the INTO statements cannot be used in a CREATE VIEW statement.
Views cannot reference temporary tables.
The CREATE VIEW statement cannot be combined with other T-SQL statements.

Techronnati | where technology never sleeps

Q What are the restrictions on views in SQL?
« on: January 06, 2009, 07:17:19 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
143 Views
Last post October 01, 2008, 01:56:05 AM
by arpee
0 Replies
158 Views
Last post October 01, 2008, 02:31:56 AM
by arpee
0 Replies
91 Views
Last post November 25, 2009, 02:53:29 AM
by MrSpecialist
1 Replies
120 Views
Last post July 22, 2016, 03:58:24 AM
by JusticeLeague
0 Replies
20 Views
Last post August 23, 2017, 10:59:22 AM
by GBTalk

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.