Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Starting and Ending Transact-SQL Statements

By: FYIcenter.com

(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,
  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...)

  1. What Is SQL Language?
  2. What Is Transact-SQL Language?
  3. What Is a Transact-SQL Statement?
  4. How To Start and End Transact-SQL Statements?
  5. How To Enter Comments in Transact-SQL Statements?
  6. What Is a Transact-SQL Statement Batch?
  7. What Happens to a Statement Batch If There Is a Compilation Error?
  8. How To Use GO Command in "sqlcmd"?
  9. How To Create User Messages with PRINT Statements?
  10. How Many Categories of Data Types Used by SQL Server?
  11. What Are Exact Numeric Data Types?
  12. What Are Approximate Numeric Data Types?
  13. What Are Date and Time Data Types?
  14. What Are Character String Data Types?
  15. What Are Unicode Character String Data Types?
  16. What Are Binary String Data Types?
  17. What Are the Differences between CHAR and NCHAR?
  18. What Are the Differences between CHAR and VARCHAR?
  19. What Are the Differences between DECIMAL and FLOAT?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...