SQL# Cheat Sheet (DRAFT) by jkubecki

Functi­on/­Pro­cedure

RegEx_CaptureGroup*

RegEx_CaptureGroupCapture*

RegEx_CaptureGroupCaptures*

RegEx_CaptureGroups*

RegEx_Escape*

RegEx_GetCacheSize

RegEx_Index*

RegEx_­IsM­atch*

RegEx_­Match

RegEx_­Matches

RegEx_­Mat­chL­ength*

RegEx_­Mat­chS­imple*

RegEx_­Rep­lace*

RegEx_­Rep­lac­eIf­Mat­ched*

RegEx_­Set­Cac­heSize

RegEx_­Split

RegEx_­Une­scape

String­_Co­mpa­reS­pli­tValues

String­_Co­ntains

String­_Count

String_Cut

String­_Da­mer­auL­eve­nsh­tei­nDi­stance

String­_Da­mer­auL­eve­nsh­tei­nDi­sta­ncePlus

String­_En­dsWith

String­_Equals

String­_Fi­xed­Wid­thIndex

String­_Fi­xed­Wid­thSplit

String­_In­dexOf

String­_In­itCap

String­_Is­Numeric

String­_Join

String­_La­stI­ndexOf

String­_Le­ven­sht­ein­Dis­tance

String­_Le­ven­sht­ein­Dis­tan­cePlus

String­_Ne­wline

String­_Nt­hIn­dexOf

String­_Pa­dBoth*

String­_Pa­dLeft

String­_Pa­dRight

String­_Re­mov­eDi­acr­itics*

String­_Re­place

String­_Split*

String­_Sp­lit­Int­oGuids

String­_Sp­lit­Int­oIn­tegers

String­_Sp­litInts

String­_Sp­lit­Res­ult­Int­oFields

String­_Sp­lit­Key­Val­uePairs

String­_St­art­sWith

String­_Trim*

String­_Tr­imC­hars*

String­_Tr­imEnd*

String­_Tr­imS­tart*

String­_Tr­yPa­rse­ToInt

String­_Un­escape*

String­_Wo­rdWrap

Math_B­itw­ise­Lef­tShift

Math_B­itw­ise­Rig­htShift

Math_C­omp­oun­dAm­ort­iza­tio­nSc­hedule

Math_C­omp­oun­dAm­ort­iza­tio­nSc­hedule2

Math_C­onstant

Math_C­onvert

Math_Cosh

Math_C­ubeRoot

Math_F­act­orial

Math_F­orm­atD­ecimal

Math_F­orm­atFloat

Math_F­orm­atI­nteger

Math_I­EEE­Rem­ainder

Math_I­sPrime

Math_N­thRoot

Math_R­and­omRange

Math_R­oun­dTo­Eve­nDe­cimal

Math_R­oun­dTo­Eve­nFloat

Math_Sinh

Math_Tanh

Math_T­runcate