Snipplr

(C#) Simple CSV Writer - hoffstein

Tue, 05 Oct 2010 07:19:51 UTC

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

Wed, 17 Dec 2008 11:34:47 UTC

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

(Bash) Create patch file - hoffstein

Mon, 08 Dec 2008 11:31:06 UTC

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 - hoffstein

Mon, 01 Dec 2008 16:34:59 UTC

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 - hoffstein

Mon, 01 Dec 2008 09:48:53 UTC

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 - hoffstein

Tue, 25 Nov 2008 11:20:20 UTC

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 - hoffstein

Thu, 13 Nov 2008 15:36:21 UTC

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 - hoffstein

Thu, 13 Nov 2008 14:20:50 UTC

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 - hoffstein

Mon, 10 Nov 2008 13:19:55 UTC

(DOS Batch) Create symbolic link in Vista - hoffstein

Wed, 05 Nov 2008 22:58:19 UTC

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 - hoffstein

Wed, 05 Nov 2008 10:02:10 UTC

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 - hoffstein

Tue, 04 Nov 2008 15:07:09 UTC

## 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 2³¹ 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 2³⁰ 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 2³¹ 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 - hoffstein

Tue, 04 Nov 2008 10:31:55 UTC

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 - hoffstein

Mon, 03 Nov 2008 17:20:00 UTC

Set the BackgroundColor property to the following expression.

(DOS Batch) Remove Seapine Surround SCM bindings - hoffstein

Fri, 31 Oct 2008 12:55:04 UTC

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 - hoffstein

Fri, 31 Oct 2008 11:52:04 UTC

(Other) Vim Delete All Blank Lines - hoffstein

Thu, 30 Oct 2008 14:23:14 UTC

(Other) TSQL snippets for snippetsEmu - hoffstein

Thu, 30 Oct 2008 09:47:52 UTC

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 - hoffstein

Thu, 23 Oct 2008 16:18:02 UTC

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

(C#) LINQ Conditional Sum - hoffstein

Thu, 23 Oct 2008 14:43:40 UTC

(C#) LINQ Conditional Count - hoffstein

Thu, 23 Oct 2008 14:38:17 UTC

(DOS Batch) Enable FullTrust on a network share - hoffstein

Tue, 14 Oct 2008 16:15:02 UTC

Since network shares by default only get LocalIntranet permissions, it's relatively common to want to use CasPol to fully trust some shares that you control and know are safe. To trust everything on the share \\ShawnFa-Srv\Tools, use the command below.

(SQL) TSQL keyword search - hoffstein

Tue, 14 Oct 2008 15:59:59 UTC

Searches all stored procedures and functions for a given keyword.

(SQL) TSQL last second of day - hoffstein

Tue, 14 Oct 2008 15:57:06 UTC

Returns the last second of the day for a given datetime value (@date).

(SQL) TSQL truncate time - hoffstein

Tue, 14 Oct 2008 15:54:26 UTC

Returns the date associated with a given datetime value (@date).

(SQL) TSQL delete function if it already exists - hoffstein

Tue, 14 Oct 2008 13:56:22 UTC

(SQL) TSQL delete proc if it already exists - hoffstein

Tue, 14 Oct 2008 13:55:21 UTC

(SQL) TSQL delete table if it already exists - hoffstein

Tue, 14 Oct 2008 13:52:30 UTC

(SQL) TSQL delete view if it already exists - hoffstein

Tue, 14 Oct 2008 13:49:12 UTC

(Other) Vim command line history - hoffstein

Tue, 14 Oct 2008 13:17:49 UTC

Want to see the ex commands you've executed as of late? Easy, just type q: from normal mode to open your command-line history. From the command-line history window, you can yank commands or execute them as needed. To go back to normal mode type :q. You can also enter command-line history mode from ex mode by typing ctrl-f.

(Other) Repeat last visual selection - hoffstein

Thu, 07 Aug 2008 13:45:44 UTC

(Other) Repeat last Ex command - hoffstein

Wed, 30 Jul 2008 15:01:36 UTC

(Regular Expression) Regex for keeping first word in line - hoffstein

Wed, 30 Jul 2008 14:08:54 UTC