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
3,156 reads
Describe and provide a set-based method that takes a multiple character split term and returns as a table
2018-03-19
3,156 reads
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
4,004 reads
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
2018-01-18
3,132 reads
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Databases and Disasters
Comments posted to this topic are about the item Automating SQL Server Access Review
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers