Upgrade to remove ads
SQL Server common terms
Terms in this set (8)
Data Definition Langue. This is the portion of T-SQL used to create, edit, and maintain objects
Data Manipulation Langue. This is the portion of T-SQL used to insert, update, select, and delete data.
Multiple rows of data that is returned by a DML script.
Transactional Structured Query Langue. Microsoft's proprietary implementation of the SQL langue.
A localized memory item that can be used in Stored Procedures, Stored Functions, Views and Triggers.
An attribute of an object.A variable that receives it's value from the caller of the object.
In SQL Server there are two meaning.
The most common the a general term that refers to the objects, but not the data, in a database.
There is also an object named Schema. This is an organizational and security object that can be used to group objects that share security topical usage.
The patterns that allow specific data to be selected. Constraints are most likely applied by a Where statement, but can be achieved with Join logic.
THIS SET IS OFTEN IN FOLDERS WITH...
SQL Server Objects
Basic SQL Terms
Basic SQL Statements (Commands)
YOU MIGHT ALSO LIKE...
CSCI 1302 Chap 6
CNIT 180 Exam 2