Difference between 2 tier and 3 tier architecture

Some time Question arised that what  is basic difference between 2 tier and 3 tier

Two Tier Architecture: It is nothing but client server Architecture, where client will hit request directly to server and client will get response directly from server.

Three tier Architecture: It is nothing but Web Based application,here in between client and server middle ware will be there, if client hits a request it will go to the middle ware and middle ware will send to server and vise-versa.
What is parsename function in SQL SERVER
Q: What is the parsename function in sqlserver and what is the use of this ?
A:The PARSENAME string function returns the specified part of an object name.
 The PARSENAME() function can be useful for parsing small strings. 
How to Call JavaScript function After a time interval with Jquery
use the function  setInterval() like below.
 setInterval(function () {
        YourJavaScriptFunction();
    }, 300000);
How to handle checkbox check uncheck event with Jquery
Firstly you have to load all jquery file which is required  
 
$('#myform :checkbox').click(function() {


    if ($(this).is(':checked')) {
           
        //Do your work //here check box checked code 
    } else {
        // Do your work // here check box unchecked code 
    }
});
How can I quickly identify most recently modified stored procedures or table in SQL Server











1. Select * From sys.objects where type='u' and modify_date between GETDATE()-1 and GETDATE()

Note :  use p for store procedure,tr for trigger and fn for function

OR
2. Select * From sys.objects where type='u' order by modify_date desc

Note :  use p for store procedure,tr for trigger and fn for function

you change the date accodingly in first Query
use type='p' for storeprocedure in this Query

JIT Compiler

How many type of JIT in ASP >net 

· Pre - JIT: - In Pre-JIT compilation, complete source code are converted into native code in a single cycle. This is done at the time of application deployment.
.
· Econo - JIT: - In Econo-JIT compilation, compiler compiles only those method which are called at run time. After execution of this method compiled method are removed from memory.
.
· Normal - JIT: - In Normal-JIT compilation, compiler compiles only those method which are called at run time. After executing this method, compiled method are stored in memory cache. Now further calling to compiled method will execute method from memory cached.
Difference Between Dll and EXE
This  question is genrally asked in interview and the answer is
DLL:
1)it is not self executable
2)it runs in application process memory
3)it has no entry point
4)it is reusable
5)Out Process Server

Exe:
1)it is self executable
2)it runs in own memory
3)it have main function(Entry point)
4)it is self executable
5) In Process Server

How to Refresh Parent Page

Question : The Question arise that . i have a data control and i click on this template then an window open offcourse this is the child window and we show some data on this child window . i want refresh the parent page after load the child window .How to do this
Answer:
lets take an example what you want simply when user see her/his mail then after clicking the mail the row color is chage . Exactly we want this in your project .. So there are a solution ..
write the following code on your child window page laod  or where you want

const string cRefreshParent = "<script language='javascript'>" +

    "  window.opener.document.forms(0).submit();" + "</script>";
    const string cRefreshParentKey = "RefreshParentKey";
    if (!this.Page.ClientScript.IsClientScriptBlockRegistered(cRefreshParentKey))
    {
        this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(),
        cRefreshParentKey, cRefreshParent);
    }


Difference between === and == in javascript

if(1=="1")
{
alert("hello");
}else
{
alert("hi");
}

Some time question arises that what is the output.
what you think about this ?
of course your answer is hello .
But now can you guess what is the result of following code

if(1==="1")
{

alert("hello");
}else
{
alert("hi");
}
bit confusing .
answer is hi .
It is becuase the expreesion === to compare datatype as well as value .