Snipplr - jprochazka

(C#) Check if a file is an executable.

Sat, 18 May 2013 05:02:45 GMT

A function to check the first two bytes to see if they match "MZ" marking it as an executable.

(SQL) Enable Ad Hoc Distributed Queries using sp_configure

Wed, 27 Mar 2013 03:49:23 GMT

Allows Ad Hoc Distributed Queries using by executing sp_configure.

(JavaScript) Allow only numberic key presses.

Sat, 02 Feb 2013 02:49:40 GMT

The following code allows only numeric characters to be entered.

(SQL) SQL Server: Remove extra spaces from a string.

Fri, 21 Dec 2012 23:08:08 GMT

Removes extra spaces from a string in SQL Server.

(C#) Get Entire Markup For The Supplied URL.

Sat, 15 Dec 2012 08:47:24 GMT

Returns the entire markup making up the specified webpage.

(VB.NET) Read an external url into a string variable.

Fri, 30 Nov 2012 08:30:25 GMT

Assigns the contents of a "url" to the string variable "result".

(VB.NET) Get the MIME type of a file.

Thu, 29 Nov 2012 03:07:25 GMT

By running the function GetMimeType(file.name) the following code will return the MIME type for a file.

(PHP) Return a string between two strings or tags.

Fri, 09 Nov 2012 18:05:11 GMT

Returns the contents of a string between two unique strings. Useful for returning the portion of a string found between two tags such as and

(SQL) Microsoft SQL Server: Back up all transaction logs.

Tue, 06 Nov 2012 08:14:25 GMT

Backs up all database transaction logs within a Microsoft SQL Server instance except for databases set to simple recovery mode.

(SQL) Microsoft SQL Server: Back up all databases.

Tue, 06 Nov 2012 08:11:50 GMT

Backs up all databases contained in a Microsoft SQL Server instance.

(SQL) Microsoft SQL Server: Rename a database schema.

Sat, 13 Aug 2011 01:15:34 GMT

Generates a set of queries to run which will change the schema for all items within a specified schema and change them to another.

(SQL) Microsoft SQL Server: Find and replace.

Tue, 11 Jan 2011 06:06:09 GMT

Clears supplied text from database tables. Does not clear the string out of TEXT or NTEXT tables.

(JavaScript) Validate an email address. (advanced)

Sat, 02 Oct 2010 01:42:59 GMT

The following JavaScript will validate an email address using strict rules when a form is submitted.

(PHP) Validate an email address.

Sat, 02 Oct 2010 01:37:40 GMT

The following function does a very simple check on the supplied string to help ensure it is a valid email address.

(PHP) Validate a domain name.

Sat, 02 Oct 2010 01:37:35 GMT

The following function validates and returns TRUE or FALSE if the supplied string could be a valid domain name format.

(PHP) Get a visitor\'s real IP address.

Sat, 02 Oct 2010 01:37:05 GMT

A more reliable way to obtain a visitor's IP address.

(PHP) Make a \"SEO Friendly URL\" string.

Sat, 02 Oct 2010 01:36:46 GMT

The following function will return a SEO friendly URL using a supplied string.

(PHP) Send an email. (simple)

Sat, 02 Oct 2010 01:36:42 GMT

A simple example of how to send an email using PHP's build in mail() function.

(PHP) Find the \"SEO Friendly\" title in a URL.

Sat, 02 Oct 2010 01:36:22 GMT

Finds an "SEO Friendly" title placed in the URL after the domain and returns the value.

(PHP) Get a directory listing.

Sat, 02 Oct 2010 01:34:52 GMT

List files within a directory while ignoring system folders such as "Thumbs.db" as well as "." and "..".