Overview of Sybase SQL language

SQL (Structured Query language) is a kind of international standard of relational database language, it is a kind of non procedural language. By writing SQL, we can implement all the operations on the relational database.

Data definition Language (DDL)--building and managing database objects

Data manipulation Language (DML)--for querying and updating data

Data Control Language (DCL)--Control of data security

The T-SQL language is an extension of Sybase's standard for SQL92, which adds three features: its own data type/unique SQL function/Process Control function

Description of identifiers used in T-sql:

(1) An identifier is composed of 1-30 characters or digits, but the first character must be a letter. The table name of a temporary table begins with a # and cannot exceed 13 characters in length.

(2) Examples of identification methods for database objects

Database.owner.tablename.columnname

To execute a remote stored procedure:

EXEC Server.db.owner.proc_name

When executing a statement at the beginning of a batch, exec can omit it.