Get All Relationship of Primary Key

SELECT
    PKTableInfo.TABLE_NAME AS PK_Table_Name
    , ConstarintReference.UNIQUE_CONSTRAINT_NAME AS PK_CONSTRAINT_NAME
    , STUFF( (
                SELECT
                    ',' + kcu.COLUMN_NAME
                FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE  AS kcu
                WHERE kcu.TABLE_CATALOG = PKTableInfo.TABLE_CATALOG
                    AND kcu.TABLE_SCHEMA = PKTableInfo.TABLE_SCHEMA
                    AND kcu.TABLE_NAME = PKTableInfo.TABLE_NAME
                    AND kcu.CONSTRAINT_CATALOG = PKTableInfo.CONSTRAINT_CATALOG
                    AND kcu.CONSTRAINT_SCHEMA = PKTableInfo.CONSTRAINT_SCHEMA
                    AND kcu.CONSTRAINT_NAME = PKTableInfo.CONSTRAINT_NAME
                ORDER BY kcu.ORDINAL_POSITION
                FOR XML PATH('')
            ), 1, 1, '') AS [PK_CONSTRAINT_COLUMNS]
    , FKTableInfo.TABLE_NAME AS FK_Table_Name
    , ConstarintReference.CONSTRAINT_NAME AS FK_CONSTRAINT_NAME
    , STUFF( (
                SELECT
                    ',' + kcu.COLUMN_NAME
                FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE  AS kcu
                WHERE kcu.TABLE_CATALOG = FKTableInfo.TABLE_CATALOG
                    AND kcu.TABLE_SCHEMA = FKTableInfo.TABLE_SCHEMA
                    AND kcu.TABLE_NAME = FKTableInfo.TABLE_NAME
                    AND kcu.CONSTRAINT_CATALOG = FKTableInfo.CONSTRAINT_CATALOG
                    AND kcu.CONSTRAINT_SCHEMA = FKTableInfo.CONSTRAINT_SCHEMA
                    AND kcu.CONSTRAINT_NAME = FKTableInfo.CONSTRAINT_NAME
                ORDER BY kcu.ORDINAL_POSITION
                FOR XML PATH('')
            ), 1, 1, '') AS [FK_CONSTRAINT_COLUMNS]
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS  AS ConstarintReference
    INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE AS PKTableInfo ON PKTableInfo.CONSTRAINT_CATALOG = ConstarintReference.UNIQUE_CONSTRAINT_CATALOG
        AND PKTableInfo.CONSTRAINT_SCHEMA = ConstarintReference.UNIQUE_CONSTRAINT_SCHEMA
        AND PKTableInfo.CONSTRAINT_NAME = ConstarintReference.UNIQUE_CONSTRAINT_NAME
    INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE AS FKTableInfo ON ConstarintReference.CONSTRAINT_CATALOG = FKTableInfo.CONSTRAINT_CATALOG
        AND ConstarintReference.CONSTRAINT_SCHEMA = FKTableInfo.CONSTRAINT_SCHEMA
        AND ConstarintReference.CONSTRAINT_NAME = FKTableInfo.CONSTRAINT_NAME
ORDER BY PK_Table_Name, FK_Table_Name
GO

Get detailed error handling information in SQL

Refer this link

http://msdn.microsoft.com/en-us/library/ms175976.aspx

Searching and Multipal Selection Criteria in JQuery

    <div>
        <div style="float: left; width: 150px">
            Your Gender :
        </div>
        <div style="float: left; width: 250px">
            <asp:RadioButtonList ID="rdbGender" runat="server">
                <asp:ListItem Text="Male" Value="1"></asp:ListItem>
                <asp:ListItem Text="Female" Value="0"></asp:ListItem>
            </asp:RadioButtonList>
        </div>
    </div>
    <div style="clear: both">
        <div style="float: left; width: 150px">
            Searching :
        </div>
        <div style="float: left; width: 250px">
            <asp:RadioButtonList ID="rdbSearching" runat="server">
                <asp:ListItem Text="Groom" Value="1"></asp:ListItem>
                <asp:ListItem Text="Bride" Value="0"></asp:ListItem>
            </asp:RadioButtonList>
        </div>
    </div>

    <script type="text/javascript" language="javascript">
        $(document).ready(function() {
            $("input[id*='rdbGender'], input[id*='rdbSearching']").click(function() {

                var foundIn = $(this).attr('id').toString().search(new RegExp(/rdbGender/i));

                var strOpositeRadioButton = "rdbGender";

                if (foundIn > -1) {
                    strOpositeRadioButton = "rdbSearching";
                }

                if ($(this).val() == 1) {
                    $("input[id*=" + strOpositeRadioButton + "][value=0]").attr("checked", "checked");
                }
                else {
                    $("input[id*=" + strOpositeRadioButton + "][value=1]").attr("checked", "checked");
                }
            });
        });
    </script>

JQuery

Ready
-----------------------------------
$(document).read(function(){
    alert('hi');
})

$(document).read(FormSetting)
Function FormSetting()
{
    alert('hi');
}
-----------------------------------

Selection Criteria
-----------------------------------
=> ID
   $("#txtUserName")

=> Control
   $("input")
   $("div")

=> Inner Control
   $("div div input")

=> Class
   $(".button")

=> Selection on standard attributes
   $("input[type='button']") 

=> Selection on custome attributes
   <input type="text" IsGridText="True" />
   $("input[IsGridText ='True']")
-----------------------------------

Functions
-----------------------------------
=> VAL()
   Var strUserName = $("#txtUserName).val();
   $("#txtUserName).val("jsd24");

=> HTML()
   Var strInnerHtml = $("#divUserInfo).html();
   $("#divUserInfo).html("<a href='#'     OnClick='Alert(1)'>Click Me</a>");

=> Attr ( attribute)
   var IsGridText = $("#txtUserName").attr("IsGridText");
   $("#txtUserName").attr("IsGridText", "False");
   $("#txtUserName").attr({IsGridText:'True', IsSelected:'True'});

=> Css (style sheet)
   var color = $("#txtUserName").css("color");
   $("#txtUserName").css("color", "red");
   $("#txtUserName").css({'width': '100px', 'height':'25px'});
 
=> Each
   $("input").each(function() { $(this).val("jd"); })

=> addClass()
   $("input[type='button']").addClass("button");

=> removeClass()
   $("input[type='button']").removeClass("button");

=> haseClass()
   $("#txtUserName").haseClass("UserName");
   $("#txtUserName").haseClass("EmailID");

=> toggleClass()
   $("#divUserInfo").toggleClass("Content");

=> height()
   $("#divUserInfo").height();

=> innerHeight()
   $("#divUserInfo").innerHeight();

=> outerHeight()
   $("#divUserInfo").outerHeight();

=> width()
   $("#divUserInfo").width();

=> innerWidth ()
   $("#divUserInfo").innerWidth ();

=> outerWidth ()
   $("#divUserInfo").outerWidth ();

=> fadeIn()
   $("#divUserInfo").fadeIn();

=> fadeOut()
   $("#divUserInfo").fadeOut ();

=> hide()
   $("#divUserInfo").hide();

=> show()
   $("#divUserInfo").show();

=> appendTo    
$("Hello").appendTo("#divUserInfo");

=> clone
$("#divUserInfo").clone().appendTo("#divUserInfo1");

=> not
$("#ddlProductList option").not("[value*='Computer']").clone().appendTo("#ddlFilterList");
-----------------------------------

Multiple Action in single line
-----------------------------------
$("#txtUserName").val("JSD24").css("color", "green").attr("IsSelected", "true")
-----------------------------------

Events
-----------------------------------
=> change()
   $("#txtUserName").change(function(){});
   
=> click()
   $("a").click(function(){});

=> dblclick()
   $("a").dblclick(function(){});

=> focus()
   $("#txtUserName").focus();

=> focusIn()
   $("#txtUserName").focusIn(function());

=> focusOut()
   $("#txtUserName").focusOut(function());

=> hover()
   $("#txtUserName").hover(function());

=> keydown()
   $("#txtUserName").keydown(function());

=> keyup()
   $("#txtUserName").keyup(function());

=> keypress ()
   $("#txtUserName").keypress(function());

=> mousedown()
   $("#txtUserName").mousedown(function());

=> mouseup()
   $("#txtUserName").mouseup(function());

=> mousemove()
   $("#txtUserName").mousemove(function());
-----------------------------------

AJAX / JSON
-----------------------------------
$.ajax({
        url : "test.html",
        type:"GET" ,         //Post
        data : { id : "2", pid : "1" },
        context: document.body,
        datatype : "html"        //JSON, XML
        success : handleResponse,
        error : handleError
});

Function handleResponse(data)
{
    alert(data);
}

Function handleError(msg)
{
    alert(msg);
}
-----------------------------------

Using Enum in Javascript

<script type="text/javascript" language="javascript">
    var enumTabInfo = { 
                        BasicInformation: 1, 
                        SkillDetail: 2, 
                        EducationDetail: 3, 
                        ProjectDetail: 4, 
                        CompanyDetail: 5 
                      }
    
    $(document).ready(function(){ 
        $("div.UserTab").Hide();
        
        var intTabNo = Number($("#<%= hdnCurrentTab.ClientID %>").val());

        switch (intTabNo) {
            case enumPageStep.BasicInformation:
                $("#divBasicInformation").show();
                break;

            case enumPageStep.SkillDetail:
                $("#divSkillDetail").show();
                break;

            case enumPageStep.EducationDetail:
                $("#divEducationDetail").show();
                break;

            case enumPageStep.ProjectDetail:
                $("#divProjectDetail").show();
                break;

            case enumPageStep.CompanyDetail:
                $("#divCompanyDetail").show();
                break;
        }
    });
</script>

Enum Extention

Enum Extention :

    public static class EnumExtention
    {
        public static Dictionary<int, string> GetEnumData(this Type EnumType)
        {
            Dictionary<int, string> objEnumList = new Dictionary<int, string>();

            if (EnumType != null && EnumType.IsEnum)
            {
                foreach (int intCount in Enum.GetValues(EnumType))
                {
                    objEnumList.Add(intCount, Enum.GetName(EnumType, intCount).ToString().Replace("_", " "));
                }
            }
            return objEnumList;
        }
    }

Get Enum Data :

        private enum enumUserType
        {
            Admin,
            Sales_Department,
            Purchase_Department,
            Guest
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            ddlUserType.DataSource = typeof(enumUserType).GetEnumData();
            
            ddlUserType.DataTextField = "Value";
            ddlUserType.DataValueField = "Key";

            ddlUserType.DataBind();
        }

Output :

<select name="ddlUserType" id="ddlUserType">
    <option value="1">Admin</option>
    <option value="2">Sales Department</option>
    <option value="3">Purchase Department</option>
    <option value="4">Guest</option> 
</select>

OUTPUT Clause

SQL QUERY :

    CREATE TABLE #tblSource ( ID INT, GroupID INT, Name VARCHAR(10) )
    CREATE TABLE #tblTarget ( ID INT, GroupID INT, Name VARCHAR(10) )
    CREATE TABLE #tblOutPut ( OutputAction VARCHAR(20), ID INT, GroupID INT, NewValueName VARCHAR(10), OldValueName VARCHAR(10) )
    
    INSERT INTO #tblSource VALUES (1,1,'a11')
    INSERT INTO #tblSource VALUES (2,1,'a21')
    INSERT INTO #tblSource VALUES (3,1,'a31')
    
    --- Inserted
    BEGIN
        INSERT INTO #tblTarget
                OUTPUT 
                    'Inserted' AS OutputAction
                    , INSERTED.ID 
                    , INSERTED.GroupID
                    , INSERTED.Name
                    , NULL
                INTO #tblOutPut
            SELECT * FROM #tblSource
            UNION ALL
            SELECT ID + 10, GroupID, Name FROM #tblSource;
    END
    
    --- Updated
    BEGIN
        UPDATE #tblTarget
        SET Name = CAST(ID AS VARCHAR) + ' : ' + Name
        OUTPUT 
            'Updated' AS OutputAction
            , INSERTED.ID 
            , INSERTED.GroupID
            , INSERTED.Name
            , deleted.Name
        INTO #tblOutPut;
    END
    
    --- Deleted
    BEGIN
        DELETE FROM #tblTarget
            OUTPUT 
                'Deleted' AS OutputAction
                , deleted.ID 
                , deleted.GroupID
                , null
                , deleted.Name
            INTO #tblOutPut
        WHERE ID >= 10;
    END
    
    SELECT * FROM #tblOutPut

    DROP TABLE #tblSource
    DROP TABLE #tblTarget
    DROP TABLE #tblOutPut

Output :

OutputAction         ID          GroupID     NewValueName OldValueName
-------------------- ----------- ----------- ------------ ------------
Inserted             1           1           a11          NULL
Inserted             2           1           a21          NULL
Inserted             3           1           a31          NULL
Inserted             11          1           a11          NULL
Inserted             12          1           a21          NULL
Inserted             13          1           a31          NULL
Updated              1           1           1 : a11      a11
Updated              2           1           2 : a21      a21
Updated              3           1           3 : a31      a31
Updated              11          1           11 : a11     a11
Updated              12          1           12 : a21     a21
Updated              13          1           13 : a31     a31
Deleted              11          1           NULL         11 : a11
Deleted              12          1           NULL         12 : a21
Deleted              13          1           NULL         13 : a31