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 OPENXML OPTION OVER PIVOT PRIMARY PROCEDURE RAISERROR RECONFIGURE REPLICATION RESTORE RETURN RIGHT ROLLBACK ROWCOUNT SELECT SET STATISTICS THEN TRAN TRANSACTION …

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 go in development, eventually there is a need to do something more. Doing some complex string building to create files …

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