Languages SQL Miscellaneous  

123 TSQL functions
download download  
important code information
author:
 Joseph Gama
minimum requirements:
123 TSQL functions description

This is a collection of 123 TSQL functions for professional, academic or learning purposes. There are many conversions hexadecimal/octal/binary/Roman numerals, mathematical functions such as hyperbolic, logic and trigonometric. Combinatorial functions such as combinations, permutations (factorial), arrangements. Other interesting functions include turning a number into plain English, Morse code, EBCDIC and vice-versa, Levenshtein Distance (linguistics), encryption, infinite precision division and number theory functions: primes, deficient, perfect, abundant, golden numbers. Validation: valid email, IP, ZIP code and many others. There are some useful string functions to count occurrences of a string within another, find a character position in a string from the end of the string, wrap, rewrap, unwrap a string, etc… Some functions are clones from Microsoft Access or VBA(IIF, date, time, IsNull, IsEmpty), others from Oracle (INITCAP, TRANSLATE, RPAD, LPAD, ADD_MONTHS, MONTHS_BETWEEN, LAST_DAY, NEXT_DAY). Base convertion(10)+Combinatorial(6)+Algebra(9)+Numeric(14)+String(24)+Date(8) Comparison, validation(27)+Logic(11)+Trigonometric(5)+Hyperbolic(9)=123 total Levenshtein Distance algorithm-original developer: Michael Gilleland (thank you for allowing me to translate the code to TSQL J ) http://www.merriampark.com/ld.htm Tested on Microsoft SQL Server 2000, BigInt should be replaced with int, in order to work with other versions of Microsoft SQL Server or Sybase. Developed or translated to TSQL by Joseph Gama. Please report any bugs and they will be fixed ASAP!


File List:
123TSQL.sql63Kb
@PSC_ReadMe_502_5.txt2Kb
Examples.pdf113Kb
TSQL functions.pdf104Kb
functions.txt14Kb
individual files/0b
individual files/dbo.A2ROMAN.UDF2Kb
individual files/dbo.ACOSEC.UDF319b
individual files/dbo.ACOSH.UDF276b
individual files/dbo.ACOT.UDF319b
individual files/dbo.ADD_MONTHS.UDF274b
individual files/dbo.ARR.UDF311b
individual files/dbo.ASCII2EBCDIC.UDF2Kb
individual files/dbo.ASEC.UDF313b
individual files/dbo.ASINH.UDF277b
individual files/dbo.ATANH.UDF277b
individual files/dbo.BINTODEC.UDF479b
individual files/dbo.CHARINDEXREV.UDF456b
individual files/dbo.COMBIN.UDF327b
individual files/dbo.COMPLEMENT1.UDF247b
individual files/dbo.COMPLEMENT2.UDF251b
individual files/dbo.COSEC.UDF308b
individual files/dbo.COSECH.UDF296b
individual files/dbo.COSH.UDF292b
individual files/dbo.COTH.UDF277b
individual files/dbo.CRYPTX8.UDF1Kb
individual files/dbo.CUBE.UDF254b
individual files/dbo.DDATE.UDF337b
individual files/dbo.DEC.UDF238b
individual files/dbo.DECTOBIN.UDF401b
individual files/dbo.DECTOHEX.UDF456b
individual files/dbo.DECTON.UDF455b
individual files/dbo.DECTOOCT.UDF400b
individual files/dbo.DEG2GRAD.UDF260b
individual files/dbo.DISTANCE.UDF346b
individual files/dbo.DIVI.UDF1Kb
individual files/dbo.DTIME.UDF337b
individual files/dbo.E.UDF236b
individual files/dbo.EBCDIC2ASCII.UDF2Kb
individual files/dbo.EQUIVALENT.UDF276b
individual files/dbo.FACTDOUBLE.UDF389b
individual files/dbo.FIBONACCI.UDF402b
individual files/dbo.FRAC.UDF262b
individual files/dbo.FROMMORSE.UDF2Kb
individual files/dbo.GCD.UDF385b
individual files/dbo.GETBIT.UDF275b
individual files/dbo.GRAD2DEG.UDF260b
individual files/dbo.GRAD2RAD.UDF262b
individual files/dbo.GREGORIAN2HIJRI.UDF311b
individual files/dbo.HEXTODEC.UDF1Kb
individual files/dbo.HIJRI2GREGORIAN.UDF305b
individual files/dbo.IIF.UDF395b
individual files/dbo.IMPLIES.UDF271b
individual files/dbo.INC.UDF238b
individual files/dbo.INCLUDED.UDF436b
individual files/dbo.INITCAP.UDF1Kb
individual files/dbo.IPOCTECT.UDF1Kb
individual files/dbo.ISABUNDNUM.UDF319b
individual files/dbo.ISALPHA.UDF1Kb
individual files/dbo.ISBIN.UDF495b
individual files/dbo.ISDEFNUM.UDF318b
individual files/dbo.ISEMPTY.UDF323b
individual files/dbo.ISEVEN.UDF264b
individual files/dbo.ISHEX.UDF1Kb
individual files/dbo.ISINTNUMBER.UDF494b
individual files/dbo.ISINTPOSNUMBER.UDF503b
individual files/dbo.ISITNULL.UDF327b
individual files/dbo.ISLETTER.UDF1Kb
individual files/dbo.ISNEG.UDF320b
individual files/dbo.ISNUMBER.UDF1Kb
individual files/dbo.ISOCT.UDF484b
individual files/dbo.ISODD.UDF257b
individual files/dbo.ISPERFNUM.UDF317b
individual files/dbo.ISPOSNUMBER.UDF511b
individual files/dbo.ISPRIME.UDF497b
individual files/dbo.ISROMAN.UDF2Kb
individual files/dbo.LAST_DAY.UDF360b
individual files/dbo.LCM.UDF282b
individual files/dbo.LEVENSHTEIN.UDF2Kb
individual files/dbo.LOG2.UDF284b
individual files/dbo.LOGN.UDF294b
individual files/dbo.LPAD.UDF343b
individual files/dbo.MAX2.UDF323b
individual files/dbo.MAX3.UDF401b
individual files/dbo.MIN2.UDF326b
individual files/dbo.MIN3.UDF402b
individual files/dbo.MONTHS_BETWEEN.UDF300b
individual files/dbo.MORSE.UDF1Kb
individual files/dbo.NAND.UDF263b
individual files/dbo.NEXT_DAY.UDF425b
individual files/dbo.NINT.UDF266b
individual files/dbo.NOR.UDF261b
individual files/dbo.NROOT.UDF260b
individual files/dbo.NTODEC.UDF1Kb
individual files/dbo.NUMBERTOWORDS.UDF5Kb
individual files/dbo.OCTTODEC.UDF477b
individual files/dbo.PALINDROME.UDF467b
individual files/dbo.PALINDROMEW.UDF432b
individual files/dbo.PENTIUMBUG.UDF341b
individual files/dbo.PERFNUMBER.UDF270b
individual files/dbo.PHI.UDF284b
individual files/dbo.PROPERCASE.UDF1Kb
individual files/dbo.RAD2GRAD.UDF262b
individual files/dbo.RESETBIT.UDF266b
individual files/dbo.REWRAP.UDF1Kb
individual files/dbo.ROMAN2A.UDF1Kb
individual files/dbo.RPAD.UDF342b
individual files/dbo.SEC.UDF304b
individual files/dbo.SECH.UDF292b
individual files/dbo.SETBIT.UDF261b
individual files/dbo.SHIFTLEFT.UDF268b
individual files/dbo.SHIFTRIGHT.UDF270b
individual files/dbo.SINH.UDF290b
individual files/dbo.SLOPE.UDF327b
individual files/dbo.SQRTPI.UDF261b
individual files/dbo.STRIPL.UDF285b
individual files/dbo.STRIPR.UDF322b
individual files/dbo.SUMALIQUOT.UDF375b
individual files/dbo.SUMSEQ.UDF274b
individual files/dbo.TANH.UDF275b
individual files/dbo.TRANSLATE.UDF498b
individual files/dbo.TRIM.UDF283b
individual files/dbo.TRUNC.UDF260b
individual files/dbo.UNWRAP.UDF330b
individual files/dbo.VAL.UDF381b
individual files/dbo.VALIDEMAIL.UDF1Kb
individual files/dbo.VALIDIP.UDF1Kb
individual files/dbo.VALIDZIP.UDF352b
individual files/dbo.VALIDZIP9.UDF381b
individual files/dbo.WORDCOUNT.UDF1Kb
individual files/dbo.WRAP.UDF457b
individual files/dbo.XORCHAR.UDF1Kb
individual files/dbo.fact.UDF372b
Similar code
ASP Calender (Popularity: ) : Events calender 19 July 2002 Whats in the zip file: A complete calender example. Input form, display page and automatic ...
User reviews

2 user reviews. Read now.


Write a review:
1 2 3 4 5 6 7 8 9 10
1=poor 10=excellent
Write review*
Your name*
Email*
  (Comments are moderated, and will not appear on this site until the editor has approved them)
 
Rate me
supported os
stats
downloads 1515
version
size in Kb 220
popularity   64196/5554180
user rating 5/10
ad


New Code
Popular Code