Snipplr - hoffstein

(C#) Simple CSV Writer

Tue, 05 Oct 2010 07:19:51 GMT

(C#) C# Extension Method To Add ForEach To Any IEnumerable

Wed, 17 Dec 2008 11:34:47 GMT

This will allow you to use the LINQ ForEach method on any IEnumerable.

(Bash) Create patch file

Mon, 08 Dec 2008 11:31:06 GMT

Patches are created using the diff program. When making patches, please use the -u option, or if your diff doesn't support it, -c. Ordinary (context-free) diffs are notoriously prone to errors, since line numbers tend to change when others make changes to the same source file.

(C#) C# Get Enum Members

Mon, 01 Dec 2008 16:34:59 GMT

Retrieves an array of strings corresponding to members of the given enum. Useful for looping through them at runtime.

(Other) Vim display all syntax highlighting groups

Mon, 01 Dec 2008 09:48:53 GMT

This will open a new window containing all highlight group names, displayed in their own color. It is very useful when developing a new color scheme.

(DOS Batch) SQL Server Find Differences Between Two Tables

Tue, 25 Nov 2008 11:20:20 GMT

The TableDiff utility comes with SQL Server 2005 and can report differences on schema and data. The most popular feature of TableDiff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables. Original source was a TechNet article called [Top 10 Hidden Gems In SQL Server 2005][1]. [1]: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx "Top 10 Hidden Gems in SQL Server 2005"

(Other) Vim Delete All Trailing Whitespace

Thu, 13 Nov 2008 15:36:21 GMT

This command will remove any trailing whitespace for all lines in the current buffer.

(DOS Batch) DOS command to run all SQL scripts in a path

Thu, 13 Nov 2008 14:20:50 GMT

This assumes that you have sqlcmd (comes with SQL Server client tools) installed and wish to execute every file ending in .sql within the given directory against the specified server and database using Windows Authentication.

(Regular Expression) Regex for matching floating point number

Mon, 10 Nov 2008 13:19:55 GMT

(DOS Batch) Create symbolic link in Vista

Wed, 05 Nov 2008 22:58:19 GMT

The mklink command is used to create a symbolic link. It has the following command line syntax: mklink [[/D] | [/H] | [/J]] link target * /D – Creates a directory symbolic link. Default is a file symbolic link. * /H – Creates a hard link instead of a symbolic link. * /J – Creates a Directory Junction. * link – Specifies the new symbolic link name. * target – Specifies the path (relative or absolute) that the new link refers to.

(DOS Batch) Open Windows Explorer in current directory

Wed, 05 Nov 2008 10:02:10 GMT

When executed from a DOS prompt, this command will launch a new Windows Explorer window in the current directory.

(Other) SQL Server 2005 data types

Tue, 04 Nov 2008 15:07:09 GMT

## Exact numerics Type From To bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807 int -2,147,483,648 2,147,483,647 smallint -32,768 32,767 tinyint 255 bit 1 decimal -10^38 +1 10^38 –1 numeric -10^38 +1 10^38 –1 money -922,337,203,685,477.5808 +922,337,203,685,477.5807 smallmoney -214,748.3648 +214,748.3647 numeric and decimal are Fixed precision and scale data types and are functionally equivalent. ## Approximate numerics Type From To float -1.79E + 308 1.79E + 308 real -3.40E + 38 3.40E + 38 ## datetime and smalldatetime Type From To datetime (3.33 milliseconds accuracy) Jan 1, 1753 Dec 31, 9999 smalldatetime (1 minute accuracy) Jan 1, 1900 Jun 6, 2079 ## Character Strings Type Description char Fixed-length non-Unicode character data with a maximum length of 8,000 characters. varchar Variable-length non-Unicode data with a maximum of 8,000 characters. varchar(max) Variable-length non-Unicode data with a maximum length of 231 characters (SQL Server 2005 only). text Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters. ## Unicode Character Strings Type Description nchar Fixed-length Unicode data with a maximum length of 4,000 characters. nvarchar Variable-length Unicode data with a maximum length of 4,000 characters. nvarchar(max) Variable-length Unicode data with a maximum length of 230 characters (SQL Server 2005 only). ntext Variable-length Unicode data with a maximum length of 1,073,741,823 characters. ## Binary Strings Type Description binary Fixed-length binary data with a maximum length of 8,000 bytes. varbinary Variable-length binary data with a maximum length of 8,000 bytes. varbinary(max) Variable-length binary data with a maximum length of 231 bytes (SQL Server 2005 only). image Variable-length binary data with a maximum length of 2,147,483,647 bytes.

(Bash) Grep to find files in a path containing a pattern

Tue, 04 Nov 2008 10:31:55 GMT

This will return all files in the current directory (and all subdirectories) containing "MyPattern" (replace with any regex), ignoring case-sensitivity.

(Visual Basic) SSRS Color Every Other Row In Table

Mon, 03 Nov 2008 17:20:00 GMT

Set the BackgroundColor property to the following expression.

(DOS Batch) Remove Seapine Surround SCM bindings

Fri, 31 Oct 2008 12:55:04 GMT

These commands will remove Seapine Surround bindings from a directory (and all its subdirectories). It will also remove the read-only property from all files as well as bindings to Visual Studio source control integration.

(DOS Batch) Recursively delete files in a directory

Fri, 31 Oct 2008 11:52:04 GMT

(Other) Vim Delete All Blank Lines

Thu, 30 Oct 2008 14:23:14 GMT

(Other) TSQL snippets for snippetsEmu

Thu, 30 Oct 2008 09:47:52 GMT

These snippets can be used with TSQL files (assuming .sql extension) by saving the below code to vimfiles/after/ftplugin/sql_snippets.vim. * **$proc** - creates the skeleton for a TSQL stored procedure, including dropping the old procedure if it already exists. * **$func** - creates the skeleton for a TSQL user-defined function (scalar), including dropping the old function if it already exists. * **$view** - creates the skeleton for a TSQL view, including dropping the old view if it already exists. * **$table** - creates the skeleton for a TSQL table, including dropping the old table if it already exists. * **$sum** - creates a TSQL SUM statement using the specified field and creates an alias to preserve the field name. * **$vc** - creates a varchar definition using the specified size. * **$c** - creates a char definition using the specified size. * **$d** - creates a decimal definition using the specified size and precision. * **$tv** - creates a table variable definition. * **$tt** - creates a temp table definition.

(Other) Vim convert tabs to spaces

Thu, 23 Oct 2008 16:18:02 GMT

This will force all tabs in the current buffer to be converted to spaces.

(C#) LINQ Conditional Sum

Thu, 23 Oct 2008 14:43:40 GMT