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,302 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,252 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,561 reads
Blogs
Azure SQL Database – Azure Portal Updates
By Arun Sirpal
A small but useful change has been made to the Azure Portal for Data...
SQL Server Quick Tips
By Bert Wagner
Earlier this year I made a series of videos that were played before the...
The 2019 State of DevOps Report–Webinar
By Steve Jones
Tomorrow I get to chat with another giant in the world of DevOps: Jez...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Date & Time Difference
Dear All, Am having a table where data's are saved in the below format....
Tsql/SP Code Optimization
Hi, I am working on optimizing some of Tsql code for SP's. I know...
Ask SSC