Code Snippets Archive:

 
How To Merge Two Arrays in ASP.NET?
Posted On: 11/9/2008 9:21:10 PM
A simple C# method to merge two arrays with or without duplicate items.

Format Using FOR Xml Explicit
Posted On: 11/20/2008 12:30:51 PM
The FOR XML EXPLICIT mode transforms the SQL Query results into an XML document.

Create User Logins in Sql Server
Posted On: 3/3/2009 9:50:52 AM
To add logins to a Sql Server using T-Sql query

Creating User Defined Types in Sql Server
Posted On: 3/3/2009 8:51:40 AM
Sql Server User Defined Type (UDT) is used to create new data types that do not exist in the Sql Server.

Using C# and VB in the same ASP.NET website.
Posted On: 3/3/2009 2:41:58 PM
Setting up APP_CODE directory with two different langauages(C#,VB) in Asp.Net

Loading the Web Parts in the Page Load Event
Posted On: 3/3/2009 3:21:14 PM
Work around for loading ASP.NET Web Parts in the Page Load Event

How to rename all stored procedures in SQL SERVER
Posted On: 3/4/2009 9:34:01 AM
A T-SQL query to generate rename sql commands for all available stored procedures in a database.

How to create views in Sql Server
Posted On: 3/4/2009 9:35:03 AM
A view is a stored sql query is made readily available in a usable format.

How to delete all stored procedures in a database using T-SQL
Posted On: 3/4/2009 10:10:42 AM
A T-SQL query to generate drop procedure T-Sql commands for all available stored procedures in a database.

Parsing Comma Separated Values (CSV) Into Table in T-SQL
Posted On: 3/4/2009 2:24:05 PM
Creating Table FROM Comma Separated Values (CSV)in Sql Server

How to use BIT data type in Sql Server?
Posted On: 3/5/2009 2:54:07 PM
BIT data type is a special kind of integer that could be either true or false.

How To Convert Color To HexaDecimal String in ASP.NET
Posted On: 6/17/2009 9:20:32 AM
A simple ASP.NET method to convert Color into HexaDecimal String.