SQLServerCentral: Content tagged function

Search All SQL Script Objects in All Databases for Text

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects. Read more...

By Joshua A. Walker 2013/05/21 | Source: SQLServerCentral.com | Category: stored procedures

Rating:

|

Discuss |

Briefcase | 2,396 reads

Date Format

Returns your date in the format mask you require. Read more...

By Ervin Santiago 2013/03/11 | Source: SQLServerCentral.com | Category: date

Rating:

|

Discuss |

Briefcase | 1,425 reads

A CONCAT Function For The Rest Of Us

SQL Server 2012 introduces a new string concatenation function. This can be recreated in earlier versions of SQL Server. Read more...

By Mike McQuillan 2012/06/06 | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 1,952 reads

Function to calculate and return age in text to closest minute between

Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes Read more...

By Shane Clarke 2012/06/05 | Source: SQLServerCentral.com | Category: age

Rating:

|

Discuss |

Briefcase | 916 reads

All SQL Version info in one function

This function returns all the necessary version information in a table. Read more...

By Wilfred van Dijk 2012/05/28 | Source: SQLServerCentral.com | Category: version

Rating:

|

Discuss |

Briefcase | 2,899 reads

All SQL Version info in one function

This function returns all the necessary version information in a table. Read more...

By Wilfred van Dijk 2012/05/28 | Source: SQLServerCentral.com | Category: version

Rating:

|

Discuss |

Briefcase | 2,899 reads

An Implementation of the FNV1a Hash Algorithm for SQL Server

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing Read more...

By Bret Lowery 2012/02/20 | Source: SQLServerCentral.com | Category: sqlclr

Rating:

|

Discuss |

Briefcase | 4,002 reads

Calculate Distance in Miles from Latitude and Longitude

A fast and accurate way to calculate the distance in miles between two points, based on the latitudes and longitudes. Read more...

By RBarry Young 2011/04/15 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 5,315 reads

Function to decode HTML string to ASCII

This function decode HTML string to ASCII format string. Read more...

By andre.brunaldi 2010/10/01 | Source: SQLServerCentral.com | Category: function

Rating:

|

Discuss |

Briefcase | 1,592 reads

4-4-5 Calendar Functions, Part 1

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

By Cliff Corder 2010/09/06 (first published: 2009/09/28) | Source: SQLServerCentral.com | Category: function

Rating:

|

Discuss |

Briefcase | 18,775 reads

Get daylight savings time

After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990. Read more...

By Langston Montgomery 2010/08/26 | Source: SQLServerCentral.com | Category: function

Rating:

|

Discuss |

Briefcase | 1,476 reads

return a file Last Modified Date

This function takes a UNC file as a parameter and return the last modified date Read more...

By egpotus 2010/01/13 | Source: SQLServerCentral.com | Category: function

Rating:

|

Discuss |

Briefcase | 949 reads

4-4-5 Calendar Functions, Part 2

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

By Cliff Corder 2010/01/11 | Source: SQLServerCentral.com | Category: function

Rating:

|

Discuss |

Briefcase | 8,356 reads

SSRS Expressions Tips and Tricks

Some of the expressions and functions that have come in handy while developing reports in SSRS Read more...

By Frank Fernando 2009/12/21 | Source: SQLServerCentral.com | Category: reporting services (ssrs)

Rating:

|

Discuss |

Briefcase | 18,359 reads

4-4-5 Calendar Functions, Part 1

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

By Cliff Corder 2010/09/06 (first published: 2009/09/28) | Source: SQLServerCentral.com | Category: function

Rating:

|

Discuss |

Briefcase | 18,775 reads

GetDateTimeString Function

This function gets a variable and converts to DateTime format string 'YYYYMMDDHHMM' Ex. '07/11/2009 2:05 PM' Convert to '200907111405' Read more...

By Luis Atondo 2009/07/31 | Source: SQLServerCentral.com | Category: datetime

Rating:

|

Discuss |

Briefcase | 866 reads

GetDateTime Function

This function gets a variable string and converts to DateTime format 'YYYY-MM-DD HH:MM' Ex. '200907111405' Convert to '2009-07-11 14:05:00' Read more...

By Luis Atondo 2009/07/30 | Source: SQLServerCentral.com | Category: convert

Rating:

|

Discuss |

Briefcase | 995 reads