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.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

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

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.