2021-11-29
649 reads
SUBSTRING
2018-03-08
1,166 reads
Equivalent Oracle's INSTR Function in SQL server
Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.
2016-11-17 (first published: 2016-11-04)
1,230 reads
Split String Function
This In-line Table Valued Function returns a table with individual records parsed from a string.
2016-08-26 (first published: 2015-04-01)
4,951 reads
Format Currency Into a String
I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.
2013-05-13 (first published: 2013-05-03)
1,039 reads
Blogs
Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
Azure chaos STUDIO
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Forums
Delayed tcp acknowledgement registry setting
Our IT department contacted me recently and asked if they should change the default...
Fact Table - Various Grains
Hi there, I'm on a team developing an enterprise data warehouse for our organization....
PostgreSQL Copy
Comments posted to this topic are about the item PostgreSQL Copy
Ask SSC