| select OBJECT_NAME(triggers.parent_id) as [object_name], | |
| triggers.name, | |
| triggers.parent_class_desc, | |
| triggers.type_desc, | |
| triggers.is_disabled, | |
| triggers.is_instead_of_trigger, | |
| OBJECT_DEFINITION(triggers.object_id) | |
| as trigger_definition | |
| from sys.triggers |
| Function ColumnLetter(colNum As Long) As String | |
| Dim vArr | |
| vArr = Split(Cells(1, colNum).Address(True, False), "$") | |
| ColumnLetter = vArr(0) | |
| End Function |
| ' Code based on snippet from John Walkenbach | |
| Function FileExists(fileName) As Boolean | |
| FileExists = Dir(fileName) <> "" | |
| End Function | |
| Function PathExists(pathName) As Boolean | |
| ' Returns TRUE if the path exists | |
| On Error Resume Next | |
| PathExists = (GetAttr(pathName) And vbDirectory) = vbDirectory |
| Function RemoveInvalidCharacters(cleanMe As String) As String | |
| Dim objRegex As Object | |
| Set objRegex = CreateObject("vbscript.regexp") | |
| With objRegex | |
| .Global = True | |
| .Pattern = "[\<\>\*\'\,\$\#\@\.\""\?\!\/\[\]\:\|\\\/\?|]" | |
| RemoveInvalidCharacters = .Replace(cleanMe, "") | |
| End With | |
| End Function |
| static string GetPluralized(string word, int count) | |
| { | |
| return count == 1 ? word : word + "s"; | |
| } |
| /* | |
| Assumes table has populated Latitude and Longitude columns | |
| Populates the GeoLocation column from Lat ad Lon | |
| */ | |
| UPDATE [dbo].[TableX] | |
| SET [GeoLocation] = geography::Parse('POINT(' + CAST([Longitude] AS VARCHAR(20)) + ' ' + | |
| CAST([Latitude] AS VARCHAR(20)) + ')') | |
| GO |
| /* | |
| Replace COLUMNNAME with the column you are looking for... | |
| Source: Pinal Dave | |
| */ | |
| SELECT t.name AS table_name, | |
| SCHEMA_NAME(schema_id) AS schema_name, | |
| c.name AS column_name | |
| FROM sys.tables AS t |
| <!DOCTYPE html> | |
| html>head>title+link^body>(header.top>a.logo>img)+nav.primary>a{Link$}*3^(div.main>(aside.sidebar>nav>a{Sublink$}*3)+section.content>article>header>h1+p>lipsum)+footer.bottom>nav>a{social$}*3 | |
Use this to validate credit card numbers. Dashes are ignored, so users may input them if they like. Tests for Visa, Mastercard, Amex, Discover, JCB, and Diners Club. Uses two hidden fields to store the type of card entered and whether or not the number entered is a valid credit card number. Regex source: http://stackoverflow.com/questions/72768/how-do-you-detect-credit-card-type-based-on-number
A Pen by Jon Crowell on CodePen.
| public static bool isNumeric(string val, System.Globalization.NumberStyles NumberStyle) | |
| { | |
| Double result; | |
| return Double.TryParse(val, NumberStyle, | |
| System.Globalization.CultureInfo.CurrentCulture, out result); | |
| } | |
| /* | |
| USAGE: |