Skip to content
CSA Store
  • CSA Group
  • CSA OnDemandâ„¢
  • CSA Communities
  • Contact Us
  • Catalogue
    • Browse By Subject Area

      • Electrical
      • Fuels & Transportation
      • Petroleum & Natural Gas
      • Environment & Natural Resources
      • Construction & Infrastructure
      • Mechanical & Industrial Equipment
      • Nuclear
      • Health Care and Well-being
      • Worker & Public Safety
      • Management Systems
    • Browse By Publisher

      • ASME
      • ASTM
      • CSA Group
      • ESA
      • IEC
      • ISO
      • NRC
      • ORNAC
      • TSSA
      • WRHA
    • ICS Catalogue

      • Browse by International Classification of Standards (ICS Codes)
  • Subscription
    • Browse By Subject Area

      • Electrical
      • Fuels & Transportation
      • Petroleum & Natural Gas
      • Environment & Natural Resources
      • Construction & Infrastructure
      • Mechanical & Industrial Equipment
      • Nuclear
      • Health Care and Well-being
      • Worker & Public Safety
      • Management Systems
    • CSA Subscriptions

      • Overview
      • Collections
    • ICS Catalogue

      • Browse by International Classification of Standards (ICS Codes)
  • Services
Cart Icon0
×
Login / Register
English / CAD

Language

en

fr

Currency

CAD

USD

  • CSA Group
  • CSA OnDemandâ„¢
  • CSA Communities
  • Contact Us
Wishlist

Catalogue

  • Browse By Subject Area

    • Electrical
    • Fuels & Transportation
    • Petroleum & Natural Gas
    • Environment & Natural Resources
    • Construction & Infrastructure
    • Mechanical & Industrial Equipment
    • Nuclear
    • Health Care and Well-being
    • Worker & Public Safety
    • Management Systems
  • Browse By Publisher

    • ASME
    • ASTM
    • CSA Group
    • ESA
    • IEC
    • ISO
    • NRC
    • ORNAC
    • TSSA
    • WRHA
  • ICS Catalogue

    • Browse by International Classification of Standards (ICS Codes)

Subscription

  • Browse By Subject Area

    • Electrical
    • Fuels & Transportation
    • Petroleum & Natural Gas
    • Environment & Natural Resources
    • Construction & Infrastructure
    • Mechanical & Industrial Equipment
    • Nuclear
    • Health Care and Well-being
    • Worker & Public Safety
    • Management Systems
  • CSA Subscriptions

    • Overview
    • Collections
  • ICS Catalogue

    • Browse by International Classification of Standards (ICS Codes)

Services

Menu toggle Icon
Login / Register
English / CAD

Language

en

fr

Currency

CAD

USD

Wishlist Cart (
)

Search Section

    • Home
    • Subscriptions
    • ICS
    • INFORMATION TECHNOLOGY. OFFICE MACHINES
    • Languages Used In Information Technology
    • CAN/CSA-ISO/IEC 9075-2:18

    Codes & Standards - Subscribe

    CAN/CSA-ISO/IEC 9075-2:18

    Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) (Adopted ISO/IEC 9075-2:2016, fifth edition, 2016-12-15)

    SKU: 2701460 Published by CSA Group Publication Year 2018

    Product Details

    • Preface/Scope
    • Items Included
    Preface

    Standards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the SCC Mirror Committee (SMC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and Telephone Consultative Committee (ITU-T). 

    For brevity, this Standard will be referred to as CAN/CSA-ISO/IEC 9075-2 throughout. 

    This Standard supersedes CAN/CSA-ISO/IEC 9075-2:13 (adopted ISO/IEC 9075-2:2011). 

    Scope

    This part of ISO/IEC 9075 defines the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data. 

    This part of ISO/IEC 9075 specifies the syntax and semantics of a database language: 
     
    • For specifying and modifying the structure and the integrity constraints of SQL-data. 
    • For declaring and invoking operations on SQL-data and cursors. 
    • For declaring database language procedures. 
    • For embedding SQL-statements in a compilation unit that is otherwise written in a particular programming language (host language). 
    • For deriving an equivalent compilation unit in the host language. In that equivalent compilation unit, each embedded SQL-statement has been replaced by one or more statements in the host language, some of which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to executing the SQL-statement. 
    • For direct invocation of SQL-statements. 
    • To support dynamic preparation and execution of SQL-statements. 

    This part of ISO/IEC 9075 provides a vehicle for portability of data definitions and compilation units between SQL-implementations. 

    This part of ISO/IEC 9075 provides a vehicle for interconnection of SQL-implementations. 

    Implementations of this part of ISO/IEC 9075 can exist in environments that also support application programming languages, end-user query languages, report generator systems, data dictionary systems, program library systems, and distributed communication systems, as well as various tools for database design, data administration, and performance optimization.
     
    Download a list of included items
    items 1 - of 5 result(s)
    View 20 | View 100

    CAN/CSA-ISO/IEC 9075-2:18

    Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) (Adopted ISO/IEC 9075-2:2016, fifth edition, 2016-12-15)

    Active
    English

    CAN/CSA-ISO/IEC 9075-2:13 (R2017)

    Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) (Adopted ISO/IEC 9075-2:2011, fourth edition, 2011-12-15)

    Withdrawn
    English

    CAN/CSA-ISO/IEC 9075-2-09

    Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) (Adopted ISO/IEC 9075-2:2008, third edition, 2008-07-15)

    Withdrawn
    English

    CAN/CSA-ISO/IEC 9075-2-04

    Information Technology - Database Languages - SQL - Part 2: Foundation (SQL/Foundation) (Adopted ISO/IEC 9075-2:2003, second edition, 2003-12-15)

    Withdrawn
    English

    CAN/CSA-ISO/IEC 9075-2-01

    Information Technology - Database Languages - SQL - Part 2: Foundation (SQL/Foundation) (Adopted ISO/IEC 9075-2:1999, first edition, 1999-12-01)

    Withdrawn
    English
    copyright imgRequest Copyright Permissions

    Subscribe

    Annual subscription keeps you up-to-date with the latest editions of standards and includes all supported languages and archive versions. 

    * Price is for up to 10 users. Select the number of users required on the cart page. Subscription must include a minimum of 10 standards or a collection to proceed to checkout.

    Includes annual access to:

           • Newest and previous editions in PDF format 
           • Revisions, updates and amendments 
           • All supported languages 

    Learn More

    PDF

    English

    Go to additional format options
    • FAQs
    • Contact Us
    • Email Product

    GST REG No R119441681
    QST REG No R1006017360

    Compare Formats

    Determine the subscription format that is right for you.

    Features CSA AdvantageTM CSA OnDemandTM
    Offline access
    Full-text search
    Create highlights and personal notes
    Newest editions added automatically
    Includes all supported languages and archive versions
    My Files - create customized files by adding multiple clauses, tables or figures from the standard into your own personal File for quick reference
    Toggle between your files and the full standard to maintain context
    Instantly preview cross referenced material within the book
    Export personal notes to Excel
    Transfer notes and highlights when updates are available
    Adobe Reader PDF and browser compatible for iOS and Android
    Web, Android, iOS Compatible

    Follow Us On Social Media

    Get Our Newsletter

    Get CSA Newsletter

    • About CSA Store
    • Subscription
    • Services
    • Catalogue
    • FAQ
    • Return Policy
    • FULFILLMENT DETAILS
    • EBOOK SUPPORT
    • Product Updates
    • Contact Us
    • CSA GROUP
    • CSA COMMUNITIES
    • CSA Update Service
    • About CSA Store
    • Subscription
    • Services
    • Catalogue
    • FAQ
    • Return Policy
    • FULFILLMENT DETAILS
    • EBOOK SUPPORT
    • Product Updates
    • Contact Us
    • CSA GROUP
    • CSA COMMUNITIES
    • CSA Update Service

    • General Terms and Conditions
    • Privacy Policy
    • Accessibility
    © 2022 Canadian Standards Association. All rights reserved
    logo close
    Privacy Preference Centre

    Please manage your cookie choices by switching the consent toggles on or off under the Purposes below.

    You may change your preference at any time as described in our Cookie Policy

    • Cookie Settings
    • List of Cookies
    close
      Cookies on CSA Group

      We use Cookies to create a secure and effective website experience for our customers. For more information about Cookies and how you can disable Cookies, visit our privacy policy page. Learn More

      Free Login/Registration Required

      View Access for this document is only available for viewers in Canada.

      A free user account is required to view this document.

      Login or Register