| /* | |
| This is really interesting, I had no idea. | |
| http://shapeshed.com/html5-speech-recognition-api/ | |
| HTML5 includes built in speech recognition, which is stupid easy to use: | |
| Open your console and enter: | |
| */ |
| /* | |
| Find string if it exists in any table in a database | |
| Source: http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1/#2 | |
| Found via: http://stackoverflow.com/a/9185923/138938 | |
| */ | |
| CREATE PROCEDURE FindMyData_String | |
| @DataToFind NVARCHAR(4000), | |
| @ExactMatch BIT = 0 |
| ## Ignore Visual Studio temporary files, build results, and | |
| ## files generated by popular Visual Studio add-ons. | |
| ################### | |
| # compiled source # | |
| ################### | |
| *.com | |
| *.class | |
| *.dll | |
| *.exe |
| public static bool isNumeric(string val, System.Globalization.NumberStyles NumberStyle) | |
| { | |
| Double result; | |
| return Double.TryParse(val, NumberStyle, | |
| System.Globalization.CultureInfo.CurrentCulture, out result); | |
| } | |
| /* | |
| USAGE: |
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.
| <!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 | |
| /* | |
| 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 |
| /* | |
| 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 |
| static string GetPluralized(string word, int count) | |
| { | |
| return count == 1 ? word : word + "s"; | |
| } |
| 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 |