Technical Article

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,436 reads

Technical Article

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,141 reads

Technical Article

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: )

984 reads

Technical Article

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,212 reads

Technical Article

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,099 reads

Blogs

Daily Coping 26 May 2022

By

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

Seeding an Availability Group Replica from Snapshot

By

Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...

Microsoft Build event announcements

By

There were a number of data platform announcements at Microsoft Build yesterday that I...

Read the latest Blogs

Forums

Account logging - pwd change/db access change

By Warren Peace

Is there a way to continuously log account changes? For SQL accounts log for...

Starting on Monday

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Starting on Monday

Charindex values of a substring inside a long sentence

By SQL_Hunt

I need to gather the starting position of the keyword "sql" from a sql...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers