You are here: Data Services > Oledb Component > SQL Statement Support > SQL Best Practices

SQL Best Practices

Specify only the required columns within the SQL statement to reduce the amount of data transferred.

Delimit any name that has embedded spaces or special characters within double quote characters. You may also use [ and ] to delimit names.

Each table has a corresponding view whose name is prefixed with "Simple View of ". The simple views will always use the string data type (except for Clips, which are always the binary data type). Use simple views if you are concerned about backward compatibility in future releases.

WARNING:Do not use the names of the NCS Header columns as names of fields in the Output Record Definition in the application definition. For a list of those names, see Master Table Definition

Do not use Master as the name of a document in the application definition.

See also

Data Services Technical Overview

SQL Statements Accepted by the Data Provider

SELECT SQL Statement

UPDATE SQL Statement

INSERT INTO SQL Statement

DELETE FROM SQL Statement

 

 

See Help on Help for additional information on using this help file.

See Scantron Technical Support for additional information on technical support and training options.

See the ScanTools Suite System Requirements for further details on hardware and software requirements.

ScanTools is a suite of products; the specific information you want may appear in the help for a different module. If you don't find what you're looking for here, try one of the following:

  

Scantron Corporation

Customer Service (forms, products, and services):

1-800-SCANTRON (722-6876)

www.scantron.com

Technical Support:

1-800-445-3141

[email protected]

Copyright © 1998-2012 Scantron Corporation. All rights reserved. Use permitted only under license. www.scantron.com. No part of the Help or user guides may be reproduced in any form, or by any means, without express permission from Scantron Corporation.

LINKS TO THIRD PARTY SITES

This help system may contain links to third party websites ("Linked Sites"). The Linked Sites are not under the control of Scantron and Scantron is not responsible for the content of any Linked Site, including without limitation any link contained in a Linked Site or any changes or modifications to a Linked Site. Scantron is not responsible for web casting or any other form of transmission received from any Linked Site. Scantron provides Users with the ability to link the Assessment System to the Linked Sites as a convenience to you, and the inclusion of any link does not imply endorsement by Scantron of the Linked Site or any association with its operators.