SQL Server FAQ - Starting and Ending Transact-SQL Statements

Home >> FAQs/Tutorials >> SQL Server FAQ

By: FYIcenter.com

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,
  notes VARCHAR(1024),
  counts INT,
  created DATETIME NOT NULL DEFAULT(getdate()));
 
SeLeCT 'Welcome to FYIcenter.com SQL Server!';

Print 'Come visit this page again!'

(Continued on next topic...)