[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 865
  • Last Modified:

Why is PLAN a Reserved Word in SQL Server ?

What is the purpose of PLAN and is there and example on how to use it ? I was not able to find it in. Books Online or Google


Thanks
0
OcTella
Asked:
OcTella
6 Solutions
 
Chris MangusDatabase AdministratorCommented:
Because of the USE PLAN query hint.
0
 
dreadyCommented:
Because of the USE PLAN feature. You should be able to find that in BOL. Or here:

http://msdn2.microsoft.com/en-us/library/ms190788.aspx

Dready
0
 
David ToddSenior DBACommented:
Hi,

For SQL 2000 BOL look up hints in the index, select query hints, and select hints in Accessing and Changing Relational Data.

On the first pages is ROBUST PLAN.

Regards
  David
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
ursangelCommented:
USE Plan query hint hint works by accepting the query plan that you want to use in XML format as an argument. Plan forcing removes the ability of the query optimizer to adapt to changing data sizes and distributions, new indexes, and other variables.

Thats is the reason why you get 'plan' as a reserved key word in sql server
0
 
Hemantgiri S. GoswamiCommented:
Hi,
Here is the list of reserved words in SQL Server 2000, PLAN is keyword that is used in Execution PLAN,BACKUP PLAN etc. and hence it is reserved word we can not use it
http://msdn2.microsoft.com/en-us/library/Aa238507(SQL.80).aspx

HTH
Hemantgiri S. Goswami | MS SQL Server MVP
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now