sql job is scheduling the work into server and it will 
automatically run and finish the job 
for this we have to set the time.
what is the use of the job is
1) it check the database automatically
2)take a back up of database

for this job we have to start the Sqlserver agent and 
give the date and time for this particular job

create a proxy class by using wsdl.exe.Once it done,through 
this class you can call webservice.

Server.transfer transfer the page processing from one page
to another page without making a round trip back to the
client where as response.redirect redirect to another URL
and it make a round trip back to the client.

Response.Redirect can be used to redirect to external web
sites where as the Server.Transfer can be used only to
transfer to other pages of the same web site.

Server.Transfer transfers page processing from one page
directly to the next page without making a round-trip back
to the client's browser.  This provides a faster response
with a little less overhead on the server.  Server.Transfer
does not update the clients url history list or current url.
 Response.Redirect is used to redirect the user's browser to
another page or site.  This performas a trip back to the
client where the client's browser is redirected to the new
page.  The user's browser history list is updated to reflect
the new address.

1.
A. Sessions may not improve performance whereas Cache will
improve site performance.

B. Sessions may change from user to user whereas a single
Cache will be maintained for the entire application.

C. Cache wont maintain any state, whereas Sessions will
maintain separate state for every user.

2.
Yes Cache is accessible through out entire application
3.
Application beacuse application object is share by entire
application.

You can use RaiseError or use the TRY CATCH Programming in 
the Stored Procedure Code.

Thanks,
Bru Medishetty
www.LearnSQLWithBru,com

select min(a.standardcost) from 
(
select distinct top 2  StandardCost
from Production.ProductCostHistory
order by standardcost desc
)a

SELECT * FROM Emp e1
WHERE 2 = (SELECT COUNT(*) FROM Emp e2 WHERE e1.Salary <= 
e2.Salary)

select top 2(salary) from emp_sal where
salary in (select sal from emp_sal order by sal desc)

Select * from EmpTbl Where Salary = (Select Max(Salary) from
EmpTbl Where Salary < (Select Max(Salary) from EmpTbl)

Select max(Salary) from employeetable where salary < (select
max(salary) from Employeetable)

select max(salary) from emp 
where salary<(select max(salary) from emp)

select  employeeid, employeeName ,Salary  from table1 where 
Salary =(select min(a.Salary) from table1 inner join 
(select top 2 Salary from table1 
order by Salary desc) a on table1.Salary = a.Salary)

if we change the top value we will get the n'th largest 
salary

If we had a table named Employee which had a column named 
Salary and we had to find the second highest Salary in the 
Employee table, the query for the same would be:

SELECT TOP 1 Salary FROM (SELECT TOP 2 Salary FROM Employee 
ORDER BY Salary DESC) AS E ORDER BY Salary ASC

The subquery or the inner query would return the top 2 rows 
in descending Salary order which would be:
5000
4000
The outer query would then select the top 1 row from the 
subquery results in ascending Salary order which would be:
4000

Web custom control are those controls which are placed into 
gac and user can add it in tool box.and it is difficult to 
create.and One Custom control can share diffrent 
application.

User controls are used and create for particular 
application .It easy to create  and for using it for 
dirrent application need to copy same user control on 
dirrent applications.

Web part are new feature of dot net 2.0 . by using web part 
controls user can runtime change the size,position and 
layout of controls within the web parts controls,also web 
part gives facility to hide,edit delete controls.It is in 
built controls.

Is this you are trying to do?

    class A
    {
        public int MyName { get; set; }
    }

    class B : A
    {
        public int MyName1 { get; set; }
    }

    public class TestAB
    {
        public static void Test()
        {
            A objA = new A();
            B objB = new B();



            objB = (B)objA; // Unable to cast object of type
'AdvanceLib.A' to type 'AdvanceLib.B'.
            objA = objB;

        }

    }

---

Please refer the concept of singleton in design pattren.

Application pool is created the each and every website.
Application domain is created to one domain purpose.

IIS process is w3wp;

Every application pool in IIS use it's own process; 
AppPool1 uses process 3784, AppPool2 uses process 5044
Different applications in Asp.net will use different 
AppDomain; 

AppTest2 and AppTest2 are in different AppDomain, but in 
the same process.
 
What's the point to use them?
 
Application pool and AppDomain , both of them can provide 
isolations, but use different approches. Application pool 
use the process to isolate the applications which works 
without .NET.  But AppDomain is another isolation methods 
provided by .NET.
If your server host thousands of web sites, you wont use 
thousands of the application pool to isolate the web sites, 
just becuase, too many processes running will kill the os. 
However, sometime you need application pool. One of the 
advantages for application pool is that you can config the 
identity for application pool. Also you have more flexible 
options to recyle the application pool. At least right now, 
IIS didnt provide explicit options to recyle the appdomain.

(1) Interface have no concrete methods implemented while 
abstract class can have. 

(2) Interface can come into the chain of inheritance while 
Abstract class can't.

a)for Future, we can provide extra services in Abstract 
Class ,these futures can able to access   all of its  
Clients. And also it supports reusability.
  suppose the implementer need not provide implementation 
for all the methods.
 
Where as in Interface we don’t have this future(reusability 
and extra servicess).
               each implementer need to provide 
implementation for all the methods and 
also                  we cont provide extra services in 
future.The interface should be constant.


b)Interface can support multiple  inheritance where as 
abstract class does not.

the main reason to use polymorphism is generalization, as 
you can see in case of overloading. say if i have add 
function which just add two intergers. and i have one more 
similar kind of functionality then in that case i will do 
the overloading as only my internal implemantation will 
vary.

second thing is consistency in code.

and in case of overriding main advantage is you can invoke 
child class function dynamically(means by creating the 
object of base class as normally we do). 

suppose one of my function expects my base class type 
object and i want functionality of overrided function then 
in that case i can simply write (parent obj = new child();)