Function to Split a Delimited String into a Table

This function splits a delimited string (up to 4000 characters long) into a single column table. The delimiter can be specified at the time of execution. If not specified, the delimiter defaults to a comma. The default length of each value is 100, but that can easily be changed.An example for usage:DECLARE @string NVARCHAR(4000)DECLARE @instruments […]

3.17 (6)

2007-05-25 (first published: )

5,318 reads

Backup any/all Databases (Native AND LiteSpeed friendly)

This script can run backups for any/all databases using both SQL native and Quest's SQL LiteSpeed product. It includes options for Complete (Full), Differential, and Transaction Log backups (File and File Group backups will be coming soon). It will also clean up old backups and the msdb tables accordingly.See script for a full parameter list.NOTE: […]

5 (3)

2006-10-25 (first published: )

5,118 reads

Function to return the SQL Build Number

This function returns the SQL Build Number as a nvarchar(20) string. i.e. '8.00.760' @@Version is great, but super long, and the formatting of the string has changed over the years. This helps me find out what build of SQL I'm working on in a quick and efficient manner. The script includes the drop statement as […]

5 (1)

2006-08-09 (first published: )

978 reads

Function to return the SQL Version Number

This function returns the SQL Build Number as an int. i.e. 7, 8, or 9. @@Version is great, but super long, and the formatting of the string has changed over the years. This helps me find out what version of SQL I'm working on in a quick and efficient manner. The script includes the drop […]

2006-08-08 (first published: )

1,207 reads

Stored Procedure to get Job History (with Steps)

This procedure returns the job history for any jobs run on a given day. The parameter should be entered in mm/dd/yyyy format surrounded by single quotes. I use it to produce a report of any jobs that failed on any given day.It should be created on the MSDB database.Example: EXEC usp_job_history '10/02/2004' This is my […]

2004-10-04

2,066 reads

Blogs

Basic JSON Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 30 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes

By

A project I’ve been meaning to work on for a while has been to...

Read the latest Blogs

Forums

SSIS Startup directory not found

By wburke 85918

This seems to be a common issue throughout my packages. Anywhere I try to...

What is the best way to create events from table inserts in SQL Server

By Joseph Termine

I have a SQL 20XX database in an on-premise data center that has a...

HA in General Purpose Managed Instance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item HA in General Purpose Managed...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers