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,420 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,308 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,617 reads
Blogs
How to get the Active Directory user password policy values
By SQLPals
Recently I have had to troubleshoot quite a bit of SQL login issues and...
How do you use PowerShell toc check if an active directory user locked out, disabled etc.?
By SQLPals
If your organization uses a password policy (there are very good odds these days...
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Custom Led Neon Signs suppliers
Yancheng Tianyuan Lamp Mfg CO.,Ltd(YCTY) is established in 2006. As a professional manufacturer, specialize...
3/4 Plastic Automatic Water Level Control Valve factory
About us We lived in water shortage country, waste water is big problem as...
Ask SSC