/*************************************************************************************
  *
  *        Copyright 2012 Davide Orazio Montersino http://www.davidemontersino.com
  *
  *        This program is free software: you can redistribute it and/or modify
  *        it under the terms of the GNU General Public License as published by
  *        the Free Software Foundation, either version 3 of the License, or

namespace Westwind.Utilities.Data
{
    /// <summary>
    /// This class provides an easy way to turn a DataRow 
    /// into a Dynamic object that supports direct property
    /// access to the DataRow fields.
    /// 
    /// The class also automatically fixes up DbNull values
    /// (null into .NET and DbNUll to DataRow)
    /// </summary>

CREATE PROC SearchAllTables
(
    @SearchStr nvarchar(100)
)
AS
BEGIN
    CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))
 
    SET NOCOUNT ON

Module Module1
    Public Enum PivotAction
        Sum = 1
        Min = 2
        Max = 3
        Count = 4
    End Enum
    Public Function Pivot(ByVal SourceTable As DataTable, _
                          ByVal PrimaryKeyColumn As String, _
                          ByVal PivotNameColumn As String, _

USE <%DatabaseName%>
GO
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%UserName%'
ORDER BY schema_name, table_name; 

CREATE FUNCTION [dbo].[udf_StringToTable]
(
    @string VARCHAR(MAX),
    @delimiter CHAR(1)
)
RETURNS @output TABLE(
    data VARCHAR(256)
)
BEGIN

ALTER TABLE Student
ADD Gender BIT NULL,Address3 NVARCHAR(500) null;

static readonly List<Author> quotes = new List<Author>();
 
        public static void GetAuthors()
        {
            quotes.Add(new Author() { AuthorInfo = "", FirstName = "Devin", LastName = "Rader" });
 
            quotes.Add(new Author() { AuthorInfo = "", FirstName = "Bill", LastName = "Evjen" });
 
            quotes.Add(new Author() { AuthorInfo = "", FirstName = "Devin", LastName = "Rader" });

jQuery("#list").tableDnD({
 
    onDrop: function(table, row) {
 
        var oldIndex = row.id;
 
        var newIndex = row.rowIndex;
 
        if (oldIndex == newIndex)

$(document).ready(function() {
 
    // Initialise the first table (as before)
    $("#table-1").tableDnD();
 
    // Make a nice striped effect on the table
    $("#table-2 tr:even').addClass('alt')");
 
    // Initialise the second table specifying a dragClass and an onDrop function that will display an alert
    $("#table-2").tableDnD({

// Map content before registering areas
protected void Application_Start()
{
    Content.Map<MyPortableArea>()
        .Master("~/Views/Shared/PA.master")
        .Title("PATitle")
        .Body("PAMain");
 
    AreaRegistration.RegisterAllAreas();

private static IEnumerable<Type> FindAllMessageHandlers()
{
    var iMessageHandler = typeof(IMessageHandler);
 
    var types = from type in AppDomain.CurrentDomain.GetAssemblies().SelectMany(t => t.GetTypes())
            let canInstantiate = !type.IsInterface && !type.IsAbstract && !type.IsNestedPrivate
            let isIMessageHandler = type.GetInterface(iMessageHandler.Name) != null
            where canInstantiate && isIMessageHandler
            select type;

Set NoCount ON
 
Declare @tableName varchar(200)
 
set @tableName=''
 
While exists
 
(

using System;
using System.Collections;
using System.IO;
using System.Text;
 
namespace Handlers
{
    
    /// <summary>
    /// A data-reader style interface for reading Csv (and otherwise-char-separated) files.

Imports System
Imports System.Collections
Imports System.IO
Imports System.Text
 
Namespace Handlers
 
    ''' <summary>
    ''' A data-reader style interface for reading Csv (and otherwise-char-separated) files.
    ''' </summary>

DECLARE @ParamFromDate datetime
DECLARE @ParamToDate datetime
DECLARE @ParamQueues varchar(50)
DECLARE @CurrentDate DATETIME
DECLARE @L_Start varchar(50)
DECLARE @L_End varchar(50)
DECLARE @LSQL as varchar(1500)
DECLARE @LCOL as varchar(50)
DECLARE @TableName1 varchar(50)
DECLARE @TableName2 varchar(50)