SQL Function to Split Comma Separated Values and Insert into Table
SQL Function to Split Comma Separated Values and Insert into Table
2010-11-30 (first published: 2010-11-07)
4,207 reads
String Manipulation
Change String to Title Case(Initcap)
This is simple script to change string to title case. It will take string in any case and convert it to initcap.
2010-11-12 (first published: 2010-10-19)
1,519 reads
Robyn Page's SQL Server String Manipulation Workbench
String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench, here newly revised with extra material from collaborator Phil Factor
2010-10-19
4,427 reads
Detective Stories - Changing the Case
How to change your "UPPER" or "lower" case strings to a mixed case
2010-10-18
6,090 reads
2010-07-20 (first published: 2010-06-23)
2,578 reads
2010-02-16
3,610 reads
SQL Server UDF to pad a string
Unlike other relational database management systems that shall remain nameless, SQL Server's underlying coding language, T/SQL, does not have a built-in function for padding string values. I recently took it upon myself to create my own and as you'll see I got a little carried away
2009-05-15
2,910 reads
2009-03-19 (first published: 2009-02-17)
1,440 reads
TEXT/NTEXT Find and Replace
Find And Replace any string, in the entire table with this function. Parameterized for easy use.
2009-02-26 (first published: 2009-02-09)
886 reads
Patindex
This artcle by new author Manie Verster examines the use of the PATINDEX function in T-SQL.
2008-09-11
10,389 reads
Blogs
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers