Creating My Table

What are Inline Indexes?

New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features introduced in each version. In this article, Phil Factor reviews a feature you may have missed, inline indexes. He covers the syntax and the many ways they can be used and then performs some performance tests to see if they can make a difference with table variables.

SQL Server procedure to script tables

SQL Server procedure to script all tables in a given database to one or individual files on a given path.

CREATE TABLE and Indexes

Variable datatype DDL

SQL to APS Automation

This script was designed to help make importing data from any SQL2008+ database to an APS much easier.

Legal/illegal characters in table name

Create Table FAILED!?

Get the defination of all table type in database

THis script will generate the Drop and create script for all user define table type

SQL Server CREATE TABLE syntax diagrams

Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.