Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag function Rss

Search for any content tagged function

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 20   
 

Split and concatenate function

Function for splitting the values in string, applying logic and concatenating back to string.  Read more...
Rating: |  Discuss |   Briefcase | 1,566 reads

Find Stored Procedures and Functions That Reference Certain Tables

Find any code objects that interact with a given table/view, or call another given code object.  Read more...
By Hakim Ali 2013/08/02 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 2,513 reads

FileNameSplitter

Function to split a full file name into drive, path, file name, and extension.  Read more...
By William Talada 2013/07/03 | Source: SQLServerCentral.com | Category: filename
Rating: |  Discuss |   Briefcase | 784 reads

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text  Read more...
By Shane Clarke 2013/05/27 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 571 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,863 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 | 974 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 | 2,058 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 | 3,046 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,662 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,596 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 | 979 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 | 1,029 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 | 901 reads

Splitting the string with unique delimiter.

The statement is splited into columns according the delimter and it has been captured in the table datatype.  Read more...
By Prashanth Jayaram 2009/06/29 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,106 reads

Return X Day of Month

This function will return the first, second, third, fourth or last day of a given month.  Read more...
By Justin Wagner 2009/03/03 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 1,110 reads

Function to Return Date and Time String for File Archiving

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.  Read more...
By Joshua A. Walker 2009/02/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,394 reads

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,636 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,403 reads

Two scripts to spell out numbers in words

These SQL functions will allow you to convert decimal numbers to words  Read more...
By Anthony Zackin 2009/02/02 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,476 reads

Allow Only Numbers

This function will strip out anything that is not a number (0-9)  Read more...
By Scott Williams 2008/06/25 | Source: SQLServerCentral.com | Category: numbers only
Rating: |  Discuss |   Briefcase | 1,217 reads
   Items 1 to 20 of 20