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
    • 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
  • 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
    • CSA Group
    • Electrical
    • Information & Communication Technologies
    • Languages used in IT
    • CAN/CSA-ISO/IEC 9075-2:18

    Codes & Standards - Purchase

    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: 2425717 Published by CSA Group Publication Year 2018 1779 pages

    Product Details

    • Preface/Scope
    • Editions
    • Updates
    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.
     
    items 1 - of 4 result(s)
    View 20 | View 100

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

    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

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

    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

    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

    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

    An update to this product is available.


    To receive notifications when an amendment, new edition or update is available to your standard no matter how you purchased it, please register on the Standards Update Service. After registering, enter the List ID for the relevant standard. The List ID can be found in the “CSA Standards Update” section within the first few pages of the standard you’ve purchased. Once notified, you can then update your standard accordingly.


    PDF Format Purchased from the CSA Store

    If you have purchased or subscribed to a standard from the CSA Store in PDF format, login to your CSA OnDemandTM account to access the updated PDF.


    Paper Format Purchased or Purchased from Reseller

    If you have purchased a paper copy of the standard from the CSA Store or purchased a standard in paper or PDF format from one of our resellers, login to the Standards Update Service to download the updates in PDF format. 


    eBook Format Purchased

    If you have purchased a standard in eBook format, login to the CSA Reader App to download the updated version of the standard.

    copyright imgRequest Copyright Permissions

    Buy

    Language

    Radio input

    Format

    Radio input
    • Free updates to the latest version
    • Access historical versions
    • Access all supported languages
    Learn More
    • 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 accessSelectedSelected
    Full-text searchSelectedSelected
    Create highlights and personal notesSelectedSelected
    Newest editions added automaticallySelectedSelected
    Includes all supported languages and archive versionsSelected
    My Files - create customized files by adding multiple clauses, tables or figures from the standard into your own personal File for quick referenceSelected
    Toggle between your files and the full standard to maintain contextSelected
    Instantly preview cross referenced material within the bookSelected
    Export personal notes to ExcelSelected
    Transfer notes and highlights when updates are availableSelected
    Adobe Reader PDF and browser compatible for iOS and AndroidSelected
    Web, Android, iOS CompatibleSelected

    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