@".NET Developer, ERP and
     Database Analyst"

Blog

SQL: Create C# Classes from Table Structure

These scripts are highly flexible, I have included: the connection, select/insert/update/delete commands, etc. Use to your hearts' content! Download here: Generate ...
Read More

SQL: Zeroes (or any character) before/after Field Value

A common search, it seems to me, on the internet for SQL assistance is for "how to add values to ...
Read More

SQL: Find and Replace Value

This is a modified SQL script I had found that just searched every field in a given table and can ...
Read More

SQL: Create VB.NET Classes from Table Structure

This is the VB.NET version - download here: Generate Classes from Tables or copy/paste from below. C# version is here ...
Read More

SQL: Write to File

I'm not sure of the original creator of this script (Thank you whomever you are!), but over time I have ...
Read More

Outlook Mail Signatures

I recently ran into the problem of getting the local user's mail signature for an automated email program, after much ...
Read More

Crystal Reports: How to concatenate a field in the detail section and display it in a header/footer section

I recently came across a sticky problem in Crystal Reports 2008. How to concatenate a string type field located in the ...
Read More