Mail

Technical Article

Function to return the SQL Version Number

  • Script

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

Technical Article

Function to return the SQL Build Number

  • Script

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

MIME64 Encoder and Decoder written in T-SSQL

  • Script

Here is a MIME64 encoder function written entirely in T-SQL!© 2006 Peter Larsson, Developer Workshop, all rights reservedAs long as the copyright notice is visible within the function declarationand you include a note in the documentation of your system that thesefunctions are written by me, you may use these functions for free of charge.If you […]

5 (1)

2006-11-09 (first published: )

998 reads

Blogs

What Do I Do to Relax?

By

I’ve republished an editorial today from another author, called What do you do to...

Daily Coping 9 Dec 2022

By

Today’s coping tip is to find out something new about someone you care about....

Advent of Code 2022

By

Foreword Advent of Code is an annual event in which participants solve a series of...

Read the latest Blogs

Forums

SSRS - Add end date for all SSRS subscriptions

By pwalter83

Hi, Could you please advice if it is possible to add an end date...

COLLATE Errors

By saintor1

I have been using this for a long time.   It was done initially in...

blank page

By carjara

Hi guys! The topic "Connect to SQL Server with Python to Create Tables, Insert...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Temp Alias

See possible answers