SQL Clone
SQLServerCentral is supported by Redgate
 
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 26    Older >>
 

Find function dependencies

Produces a list of functions and the objects that use them.  Read more...
By Andy Robertson 2017/05/09 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 404 reads

Remove SQL Comments

This function takes in SQL code and returns the same SQL code but with any comments removed (i.e. "/**/", "--")  Read more...
By Jordan Ryder 2017/04/13 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 554 reads

Find UDF useage

Find all stored procedures that use UDFs  Read more...
By Jim Youmans 2017/03/21 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 352 reads

Tally Generator

Inline function generating the set of numbers based on submitted parameters.   Read more...
By Sergiy Floka 2017/03/08 | Source: SQLServerCentral.com | Category: tally
Rating: |  Discuss |   Briefcase | 1,029 reads

Determine Easter Sunday

Determine what day easter sunday will be based upon the year you pass the function   Read more...
By Kraai 2016/04/25 | Source: SQLServerCentral.com | Category: easter sunday
Rating: (not yet rated) |  Discuss |   Briefcase | 389 reads

Format Date Time Function

Function do return common datatime formats of a date. select dbo.[KDT_FN_FORMATDATETIME]('LASTDAY DDDD',getdate())   Read more...
By Kraai 2016/04/26 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 917 reads

Split and concatenate function

Function for splitting the values in string, applying logic and concatenating back to string.  Read more...
Rating: |  Discuss |   Briefcase | 1,792 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 2015/04/10 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 4,533 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 | 833 reads

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text  Read more...
By Shane Clarke 2015/07/27 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,134 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 | 2,024 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 2016/08/12 | Source: SQLServerCentral.com | Category: age
Rating: |  Discuss |   Briefcase | 1,705 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,109 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,112 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,735 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,680 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 | 1,005 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,067 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 | 923 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,117 reads
   Items 1 to 20 of 26    Older >>