SQLServerCentral.com Content tagged T-SQL, UDF

Append Value to Delimited List

Fri, 04 Mar 2011 07:00:00 UT

Takes a delimited list and appends a value to the end.

Creating User-Defined Functions in Microsoft SQL Server

Tue, 28 Sep 2010 06:00:00 UT

SQL Server's own list of functions is limited as far as what is available for database developers to use in their applications. Starting with SQL Server 2000, database developers were given the ability to create their own routines that accept parameters, perform custom actions and return results.

Fun with business days, calendar tables, and test-driven development

Thu, 23 Sep 2010 06:00:00 UT

We shall discuss how to build a calendar table, and use it in calculations involving business days

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

4-4-5 Calendar Functions, Part 1

Mon, 06 Sep 2010 06:00:00 UT

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.

4-4-5 Calendar Functions, Part 2

Mon, 11 Jan 2010 07:00:00 UT

Part 2 showing how to get the Period in a 4-4-5 Calendar

Synchronize a function between two servers

Wed, 23 Dec 2009 07:00:00 UT

It's the same with spSynchStoredProcedure

4-4-5 Calendar Functions, Part 1

Mon, 06 Sep 2010 06:00:00 UT

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.