Set-Based String Splitting table function
Describe and provide a set-based method that takes a multiple character split term and returns as a table
2018-03-19
2,651 reads
bevan ward
Solve Sudoku with T-SQL - Part 1
A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.
2018-02-20
2,684 reads
Formatted ASCII Results from a SELECT
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
2018-01-18
1,938 reads
Blogs
Adding a Check Constraint to a Table–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Azure SQL Database Elasticity – Presentation Notes
By DataOnWheels
This blog covers the content and points to the code used to create the...
How To: Create Schema Only Database Copies
By gbargsley
Have you ever been asked to make a schema only copy of a database?...
Forums
Joining 2 select results into a single row
select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as...
Ask SSC