Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag function Rss

   Items 1 to 20 of 35    Older >>
 

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 | 712 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 | 327 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/03/30 | Source: SQLServerCentral.com | Category: age
Rating: |  Discuss |   Briefcase | 1,375 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,115 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,510 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 2014/09/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,735 reads

Finding “Active” Rows for the Previous Month (SQL Spackle)

SQL Server MVP Jeff Moden walks us through the classic problem of finding all the "Active" rows for the previous month using start and end dates. This is excellent for those new to T-SQL.  Read more...
By Jeff Moden 2014/01/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,369 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,736 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,510 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 | 828 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,115 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,699 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,005 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,102 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/03/30 | Source: SQLServerCentral.com | Category: age
Rating: |  Discuss |   Briefcase | 1,375 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,101 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,101 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,310 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 2014/09/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,735 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,723 reads
   Items 1 to 20 of 35    Older >>
 
Tags
t-sql (5)    
datetime (4)    
convert (3)    
date (3)    
4-4-5 accounting (2)    
administration (2)    
cast (2)    
fiscal year (2)    
miscellaneous (2)    
string manipulation (2)    
time (2)    
udf (2)    
active directory (1)    
ad (1)    
adsi (1)    
age (1)    
archive file (1)    
archiving data (1)    
ascii (1)    
c# (1)    
code (1)    
concat() (1)    
concatenate (1)    
datepart (1)    
daylight (1)    
dba (1)    
decode (1)    
easter sunday (1)    
expressions (1)    
filename (1)    
fnv (1)    
fnv1 (1)    
fnv1a (1)    
formatting (1)    
functions (1)    
geometry (1)    
gps (1)    
hash (1)    
hashing (1)    
html (1)    
len() (1)    
number to words (1)    
numbers only (1)    
reporting services (ssrs) (1)    
savings (1)    
script (1)    
scripts (1)    
spell (1)    
spherical coordinates (1)    
split (1)    
splitter (1)    
sqlclr (1)    
stored procedure (1)    
stored procedures (1)    
string (1)    
substring (1)    
text (1)    
text search (1)    
tips and tricks (1)    
useraccountcontrol (1)    
version (1)    
views (1)    
zip codes (1)