OPTION Archives - Steve Stedman

SQL Sunday Fun – Word Search with SQL Server Keywords

By SteveStedman Posted on August 11, 2013 Posted in TSQL No Comments Tagged with CLUSTERED, OPENDATASOURCE, OPENROWSET, OPTION, PRIMARY, RETURN, RIGHT, WAITFOR

The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END EXECUTE EXIT FOR FUNCTION GRANT IDENTITY INSERT KEY NOCHECK NONCLUSTERED NULL OFFSETS OPENDATASOURCE OPENQUERY OPENROWSET …

SQL Sunday Fun – Word Search with SQL Server Keywords Read more »

Using a CTE to Split a String Into Rows with Line Numbers

By SteveStedman Posted on January 19, 2013 Posted in CTE, SQL 2008, SQL 2012 No Comments Tagged with CTE, Line Number, OPTION, RETURNS, SELECT, SUBSTRING, UNION ALL

Last year while working on my CTE presentation for a SQL Saturday I added a blog post called “Using a CTE to Split a String Into Rows“, and since that posting I have used it many times. But as things …

Using a CTE to Split a String Into Rows with Line Numbers Read more »

Tag: OPTION

SQL Sunday Fun – Word Search with SQL Server Keywords

Using a CTE to Split a String Into Rows with Line Numbers

Login