All authors

Technical Article

Revise t-sql function to parse string data

Kmlakov's script, t-sql function to parse string data, posted on 1/19/2005, required the passing in text ends with the delimiter. But it is usually not the case. I rewrote the script (added one IF statement). The new script can treat the text with or without ending delimiter. The third parameter will be the number of […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2005-02-07 (first published: )

377 reads

All authors

Blogs

A Little Brainstorming with an AI

By

I was asked to do some a little thinking and brainstorming recently. Rather than...

The Mysterious Empty Table

By

It seems like no matter how long you work with a system beyond a...

Choosing to not drive the Tesla

By

I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...

Read the latest Blogs

Forums

Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022

By Noman072

Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...

Mixed Backups

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Mixed Backups

Or condition in where clause works differently in MS SQL comparing with Sybase

By james_toronto

Hello, I ran below statements in MS SQL, and got error, but fine in...

Visit the forum

Question of the Day

Mixed Backups

I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid). 

BACKUP DATABASE [complex]
    FILE = N'thirdone'
 ,  FILE = N'thirdtwo'
 ,  FILEGROUP = N'second' 
 TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' 
 WITH NOFORMAT, NOINIT,  NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

See possible answers