Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Starting and Ending Transact-SQL Statements
(Continued from previous topic...)
How To Start and End Transact-SQL Statements?
There are simple rule about writing Transact-SQL statements:
- A Transact-SQL statement should be started with a pre-defined statement keyword.
- A Transact-SQL statement should be ended with a new line (/n) or a semicolon (;).
- A Transact-SQL statement can be entered in a single line or multiple lines.
- Transact-SQL statement keywords are case-insensitive.
- Extra white space characters are ignored within Transact-SQL statements.
Here are some good examples of Transact-SQL statements:
CREATE TABLE fyi_links (id INTEGER PRIMARY KEY,
url VARCHAR(80) NOT NULL,
created DATETIME NOT NULL DEFAULT(getdate()));
SeLeCT 'Welcome to FYIcenter.com SQL Server!';
Print 'Come visit this page again!'
(Continued on next topic...)
- What Is SQL Language?
- What Is Transact-SQL Language?
- What Is a Transact-SQL Statement?
- How To Start and End Transact-SQL Statements?
- How To Enter Comments in Transact-SQL Statements?
- What Is a Transact-SQL Statement Batch?
- What Happens to a Statement Batch If There Is a Compilation Error?
- How To Use GO Command in "sqlcmd"?
- How To Create User Messages with PRINT Statements?
- How Many Categories of Data Types Used by SQL Server?
- What Are Exact Numeric Data Types?
- What Are Approximate Numeric Data Types?
- What Are Date and Time Data Types?
- What Are Character String Data Types?
- What Are Unicode Character String Data Types?
- What Are Binary String Data Types?
- What Are the Differences between CHAR and NCHAR?
- What Are the Differences between CHAR and VARCHAR?
- What Are the Differences between DECIMAL and FLOAT?