Example for Interface and Abstract class

Example for Interface :
Code:
public interface IVehicle
{
void Start();
void Drive();
void Park();
void ChangeGear(int gear);
void SwitchOff();
}
public class Vehicle : IVehicle
{
public void Start()
{
Console.WriteLine("The vehicle has been started");
}

public void Drive()
{
Console.WriteLine("The vehicle is being driven");
}

public void Park()
{
Console.WriteLine("The vehicle is being parked");
}

public void ChangeGear(int gear)
{
Console.WriteLine("Gear changed to " + gear.ToString());
}

public void SwitchOff()
{
Console.WriteLine("The vehicle has been switched off");
}
}

Example for Abstract class :
Code:
public abstract class Vehicle
{
public void Start()
{
Console.WriteLine("The vehicle has been started");
}

public abstract void Drive();
public abstract void Park();
public abstract void ChangeGear(int gear);

public void SwitchOff()
{
Console.WriteLine("The vehicle has been switched off");
}
}

public class Car : Vehicle
{
public Car()
{
}

public override void Drive()
{
Console.WriteLine("The car is being driven");
}

public override void Park()
{
Console.WriteLine("The car is being parked");
}

public override void ChangeGear(int gear)
{
Console.WriteLine("The car changed gear changed to " + gear.ToString());
}
}

இஞ்சினியர்கள் மேனேஜரிடம் கேட்க விரும்பும் பத்து கேள்விகள்.

இஞ்சினியர்கள் மேனேஜரிடம் கேட்க விரும்பும் பத்து கேள்விகள்.


1. ராத்திரி 10 மணிக்கு கூட எங்களுக்கு பர்சனல் ஒர்க் வரக்கூடாதுனு எதிர்பார்க்கறீங்க... ஆனா சாயந்திரம் 5 மணி ஆனவுடனே உங்களுக்கு மட்டும் எப்படி பர்சனல் ஒர்க் வந்துடுது...?

2. அது எப்படி நாங்க சொல்லி உங்களுக்கு ஏதாவது புரியலைனா Dont make it too complicatedனு சொல்றீங்க... ஆனா நீங்க சொல்லி எங்களுக்கு புரியலைனா He is Dumbனு சொல்றீங்க..?

3. அது எப்படி Week end எங்களுக்கு வேலை கொடுத்துட்டு சனிக்கிழமை நீங்க வீட்டுக்கு கிளம்பும் போது Happy Weekend னு கூச்சப்படாம சொல்லிட்டு போக முடியுது..?

4. அது எப்படி உங்களுக்கு ஒரு அப்ளிகேஷன் சரியா வேலை செய்யலைனா,அப்ளிகேஷன்ல பிரச்சனைனு சொல்றீங்க... அதே எங்களுக்கு வேலை செய்யலைனா, உனக்கு அப்ளிகேஷன் தெரியலைனு சொல்றீங்க..?

5. ஏதாவது நல்ல நாள் வந்தா ஏதோ உங்க வீட்ல மட்டும் விசேஷம் மாதிரி எல்லா வேலையையும் எங்க தலைல கட்றீங்களே. ஏன் எங்க வீட்லயும் விசேஷம் இருக்கும்னு உங்களுக்கு தெரிய மாட்டீங்குது..? நாங்க என்ன டெஸ்ட் ட்யூப் பேபியா...

6.. உங்களுக்கு ஊதிய உயர்வு வரலைனா மட்டும் கம்பெனி ரொம்ப மோசமாகுதுனு சொல்ற நீங்க, எங்களுக்காக மட்டும் பேச மாட்றீங்க...?

7. ஏதாவது ஒரு முக்கியமான மெயில் அனுப்ப நீங்க மறந்தா மட்டும், I was very busy in some other issueனு சொல்றீங்க. அதே நாங்க மறந்தா, you should concentrate on workனு சொல்றீங்க...?

8. ஆபிஸ் நேரத்துல நீங்க ஃபோன் பேசிட்டு இருந்தா மட்டும், அது ஏதோ தலை போற விஷயம் மாதிரி எடுத்துக்கறீங்க, அதே நாங்க பண்ணா வேலையை சரியா செய்ய மாட்றானு சொல்றீங்க...?

9. சாயந்திரம் 5 மணிக்கு நீங்க வீட்டுக்கு போறது தப்பில்லை, ஆனா அப்ப நாங்க ஒரு டீ குடிச்சிட்டு வர போனா மட்டும் ஏதோ கொலை குத்தம் செய்யற மாதிரி பாக்கறீங்க...?

10. காலைல வந்ததுல இருந்து ICICI Direct,gmail ,Geogit, Sharekhanனு செக் பண்ணிட்டு இருக்கீங்க. அதே நாங்க மதியம் சாப்பிட்டு வந்து மெயில் செக் பண்ணா மட்டும் Don't use company resources for your personal workனு சொல்றீங்க...?

ஏன் சார் ஏன்....இத்த தான்...திருக்குறள்ள

யாதெனின் யாதெனின் நீங்கியான் நோதல்
அதனின் அதனின் இலன்...

ஆப்பீசுக்கு போனா ஆணிபுடுங்காம சும்மா இருப்பதே சுகம்னு வள்ளுவர் எப்பவோ எழுதிவச்சுட்டாரு.
இந்த மேஜர்களுக்குத்தான் இது தெரிய மாட்டேங்குது..

நாங்களும் இன்ஜினியரிங் படிச்சிட்டு தான் வந்திருக்கோம்.

Left Outer join with Having in SQL Server

select p.[ProductName],count(po.ProductID)
from Products as p Left Outer join
Productorder po on p.ProductID=po.productID
GROUP By p.[ProductName],po.ProductID
HAVING (count(po.ProductID) > 0)

Personal Interview Questions

"Tell me a little about yourself."

When responding to this request, you should focus on both your personal and professional values. Always be honest, but talk about your best traits only, especially those that relate to the position for which you are applying. Highlight experiences and accomplishments you are most proud of. Here's an example:

"I'm an experienced communications specialist with extensive knowledge of public information tools and techniques. I've developed comprehensive communication plans for major public events, written dozens of articles accepted by worldwide publications, and created specialized educational programs for adults and students. I am always eager to learn new methods and procedures, and have implemented continuous improvement techniques in my past positions that saved money and increased productivity. I like working with people and enjoy group projects, but am also a self-starter who doesn't mind working on my own. I'm a volunteer with the local chapter of Special Olympics and enjoy participating in community events. My goals are to complete my Master's Degree and broaden my experiences with community relations."

Remember to tailor your response to the specific job. By studying the job announcement, you'll get a good idea of the skills and experience being sought. Work those into your response.

Consider this your own personal commercial. If the interview consisted of only this ONE chance to sell yourself, what would you say?

"What do you feel has been your greatest work-related accomplishment?"

Choose one example from your past that was important to you and helped the company you worked for. Give specific details about what you did, how you did it, and what the results were. Try to pick an accomplishment that relates to the position for which you are applying. Employers like to hear about accomplishments that reduced expenses, raised revenues, solved problems or enhanced a company's reputation

"What is your greatest strength?"

This is a great chance to highlight your best skills. Don't pick just one, focus on your top three or four. Some examples are: leadership skills, team-building skills, and organizational skills. Determine which strengths would fit best with the position for which you are applying. For example, if the job announcement stresses the ability to handle multiple tasks, you could say: "I'm good at organizational skills, prioritization and time management. But my greatest strength is my ability to effectively handle multiple projects and deadlines.

"What is your greatest weakness?"

Be careful with this one. Most interview guides will tell you to answer it with a positive trait disguised as a weakness. For example, "I tend to expect others to work as hard as I do," or "I'm a bit of a perfectionist." Interviewers have heard these "canned" answers over and over again. To stand out, be more original and state a true weakness, but then emphasize what you've done to overcome it. For example: "I've had trouble delegating duties to others because I felt I could do things better myself. This has sometimes backfired because I'd end up with more than I could handle and the quality of my work would suffer. But I've taken courses in time management and learned effective delegation techniques, and I feel I've overcome this weakness."

IMPORTANT: Be sure the weakness you talk about is NOT a key element of the position!

"How do you handle stressful situations?"

Give some examples of stressful situations you've dealt with in the past. Tell how you use time management, problem-solving or decision-making skills to reduce stress. For example, tell them that making a "to-do" list helps. Site stress-reducing techniques such as stretching and taking a break. Don't be afaid to admit that you will ask for assistance if you are feeling overwhelmed.

If it's true, say you actually work better under pressure.

"What is the toughest problem you've had to face, and how did you overcome it?"

Try to make this about a problem that faced your company and not just you or your particular work group. The bigger the problem, the better. Give specific examples of the skills and techniques you used to resolve this problem. Emphasize the successful results. Be generous in sharing credit if it was a team effort, but be sure to highlight your specific role.

"Have you ever had to discipline a problem employee? If so, how did you handle it?"

This is a likely question if the position for which you are applying requires supervisory duties. Explain how you used problem-solving skills, listening skills, and coaching skills to help the employee. If those techniques turned the employee around, be sure to say so. If those techniques failed, tell how you followed the company's policies and what the end result was.

"Why do you want this position?"

Here's where your research about the company will help you stand out among the other candidates. Explain how you've always wanted the opportunity to work with a company that... provides a vital public service, leads the industry in innovative products, whatever... find something specific about that company that you can tie in with your answer. Explain how your qualifications and goals complement the company's mission, vision and values (use specific examples). If you are applying for a position in a company for which you already work, explain how you'll be able to apply and expand on the knowledge and experience you've gained from your current position, and will be able to increase your contributions and value to the company through your new responsibilities.

"Why are you the best person for this job?"

As with all other questions, be confident and enthusiastic when you answer this. Don't try to say you are the best qualified person, because you don't know the qualifications of the other applicants. Instead, emphasize several reasons why you should be hired. For example: "I've got extensive experience in [name the appropriate field] and have the specific skills you are looking for. I'm a fast learner who adapts quickly to change and will hit the ground running. I'm dedicated and enthusiastic about helping your company meet its goals, and will provide top-quality results with minimal oversite. I'm an outstanding performer who takes pride in my work. You won't have any regrets when you hire me."

QUESTIONS YOU SHOULD ASK

Often the interviewer's last question is, "Do you have any questions for me?" Candidates who do not have questions show a lack of initiative and give the impression that they have minimal interest in the position. Stand out from those lazy job seekers by asking questions!

Have your questions ready in advance. Relate them to the company or its accomplishments/challenges (your research of the company will show and further impress the interviewer). Don't ask any question that shows that you have not done your research about the company.

Do not ask questions related to you, such as "When will I be eligible for my first raise?" or "How often will I be subjected to a performance review?" Don't bring up money. (You can do that after you are offered the job.)

In addition to specific questions you develop based on what the company does, here are some sample generic questions:

What do you enjoy most about working here?

Be sure the person you ask actually works for the company. Some organizations, especially public agencies, have interview panels in which employees from other agencies participate.

Is there anything I've mentioned that makes you think I'm not the best candidate for this job?

If they do mention something that's bothering them about you, such as lack of specific experience, this gives you a last-ditch effort to change their opinion about you. If you've thought about your possible weaknesses in advance, you should have a prepared answer to those weaknesses. For example, "I know I have limited experience in this field, but what I lack in specific experience I make up for in enthusiasm and desire to excel. I'm a fast learner and I'll work harder than anyone else to be a top producer on your team."

When do you expect to make your final decision?

Be sure to ask that! Failure to do so may give the impression that you're not that interested, and you need to know when to follow up.

ALL THE BEST dONT Worry Be-HaPPY

Readonly vs const

Within a class, const, static and readonly members are special in comparison to the other modifiers.

const vs. readonly

const and readonly perform a similar function on data members, but they have a few important differences.

const

A constant member is defined at compile time and cannot be changed at runtime. Constants are declared as a field, using the const keyword and must be initialized as they are declared. For example;

public class MyClass

{

  public const double PI = 3.14159;

}

PI cannot be changed in the application anywhere else in the code as this will cause a compiler error.

Constants must be of an integral type (sbyte, byte, short, ushort, int, uint, long, ulong, char, float, double, decimal, bool, or string), an enumeration, or a reference to null.

Since classes or structures are initialized at run time with the new keyword, and not at compile time, you can't set a constant to a class or structure.

Constants can be marked as public, private, protected, internal, or protected internal.

Constants are accessed as if they were static fields, although they cannot use the static keyword.

To use a constant outside of the class that it is declared in, you must fully qualify it using the class name.

readonly

A read only member is like a constant in that it represents an unchanging value. The difference is that a readonly member can be initialized at runtime, in a constructor as well being able to be initialized as they are declared. For example:

public class MyClass

{

  public readonly double PI = 3.14159;

}

or

public class MyClass

{

  public readonly double PI;

  public MyClass()

  {

    PI = 3.14159;

  }

}

Because a readonly field can be initialized either at the declaration or in a constructor, readonly fields can have different values depending on the constructor used. A readonly field can also be used for runtime constants as in the following example:

public static readonly uint l1 = (uint)DateTime.Now.Ticks;

Notes

• readonly members are not implicitly static, and therefore the static keyword can be applied to a readonly field explicitly if required.

• A readonly member can hold a complex object by using the new keyword at initialization.

• readonly members cannot hold enumerations.

static

Use of the static modifier to declare a static member, means that the member is no longer tied to a specific object. This means that the member can be accessed without creating an instance of the class. Only one copy of static fields and events exists, and static methods and properties can only access static fields and static events. For example:

public class Car

{

  public static int NumberOfWheels = 4;

}

The static modifier can be used with classes, fields, methods, properties, operators, events and constructors, but cannot be used with indexers, destructors, or types other than classes.

static members are initialized before the static member is accessed for the first time, and before the static constructor, if any is called. To access a static class member, use the name of the class instead of a variable name to specify the location of the member. For example:

int i = Car.NumberOfWheels;

General Interview Question

Project interview questions

1. Project skills interview questions

• Tell us about a successful project in which you participated and how you contributed to the success of that project.

• You are given the assignment of project manager and the team members have already been identified. To increase the effectiveness of your project team, what steps will you take?

• Do you understand milestones, interdependencies? Resource allocation?

• Do you know what Project Software the new company uses and is there training for it?

• What is EVM? how will you use it in managing projects?

• What is a project? and what is program?

• What are project selection methods?

• When you are assigned a project, what steps do you take to complete the project?

• As you begin your assignment as a project manager, you quickly realize that the corporate sponsor for the project no longer supports the project. What will you do?

• Your three month project is about to exceed the projected budget after the first month. What steps will you take to address the potential cost overrun?

• Companies have historically looked at technical skills, but more and more business managers are realizing that not have “people” skills tend to cripple projects.

• How many projects you handled in the past? Deadlines met? On time/ within budget? Obstacles you had to overcome?

• Which document will you refer for future decisions?

• How will you define scope?

• Do you inspect or plan for quality ?

• What is the output of scope definition process?

• What is quality management?

• What did you like about the project and dislike about the project?

• What did you learn from the project?

• What are two common but major obstacles for a project like this? What would you do in the face of these obstacles to keep your team on schedule?

• What is project charter? What are the elements in a project charter?

• What experience have you had in project management?

• Name five signs that indicate your project may fail.

• Tell us about a project in which you participated and your role in that project.

• Describe what you did in a difficult project environment to get the job done on time and on budget.

• What actions are required for successful executive sponsorship of a project?

• How did you get your last project?

• What were your specific responsibilities?

• In this field (the field you are interviewing for), what are three critically important things you must do well as a project manager in order for the project to succeed?

• What metrics would you expect to use to determine the on-going success of your project?

• What distinguishes a project from routine operations?

• What are the three constraints on a project?

• What are the five control components of a project?

• What qualifications are required to be an effective project manager?

• Your project is beginning to exceed budget and to fall behind schedule due to almost daily user change orders and increasing conflicts in user requirements. How will you address the user issues?

• You’ve encountered a delay on an early phase of your project. What actions can you take to counter the delay? Which actions will have the most effect on the result?

• What are the necessary steps to successful project management?

• How do you plan for a project?

• What is important to consider when planning a (your type of project)?

• What are things that you have found to be low priority when planning for (your type of project)?
• You have been assigned as the project manager for a team comprised of new employees just out of college and “entry-level” consulting staff. What steps can you take to insure that the project is completed against a very tight time deadline?

• What is a “project milestone”?

• What is “project float”?

• What methods have you used for estimation?

• How would you start a project?

• If you were to deliver a project to a customer, and timely delivery depended upon a sub-supplier, how would you manage the supplier? What contractual agreements would you put in place?

• Which tool would you use to define, manage and control projects?

• What is risk management and how will you plan risk response?

• What are outputs of project closure?

• What are the methods used for project estimation?

2. Leadership interview questions

• Tell me how you would react to a situation where there was more than one way to accomplish the same task, and there were very strong feelings by others on each position.

• Consider that you are in a diverse environment, out of your comfort zone. How would you rate your situational leadership style?

• Give me an example of your leadership involvement where teamwork played an important role.

• How do you handle non-productive team members?

• How do you motivate team members who are burned out, or bored?

• How do you handle team members who come to you with their personal problems?

• What are your career goals? How do you see this job affecting your goals?

• Explain how you operate interdepartmentally.

3. Judgment interview questions

• What would you do if you found out that a contractor was in a conflict of interest situation?

• If I were to contact your former employee, what would he say about your decision-making abilities?

• Give me an example of a win-win situation you have negotiated.
• Tell me about your verbal and written communication ability. How well do you represent yourself to others? What makes you think so?

• Give me an example of a stressful situation you have been in. How well did you handle it? If you had to do it over again, would you do it differently? How do you deal with stress, pressure, and unreasonable demands?

• Tell me about a tough decision you had to make?

4. Experience interview questions

• Describe what you did at your work place yesterday.

• How would you solve the following technical problem? (Describe a typical scenario that could occur in the new position.)

• What strengths did you bring to your last position?

• Describe how those contributions impacted results?

5. Competency interview questions

• Tell me about special projects or training you have had that would be relevant to this job.

• What are some things that you would not like your job to include?

• What are your current work plans? Why are you thinking about leaving your present job?

• Describe an ideal job for you.

• Why are you interested in this position?

• Describe what you think it would be like to do this job every day.

• What do you believe qualifies you for this position?

Project interview questions can be used for project management interview questions, project manager interview questions

Five Tips To Remove Stomach Fat You Can Use Today

5 Tips To Remove Stomach Fat You Can Use Today

Getting rid of belly fat isn't something that you can do overnight, but there are methods that you can put in place today that will greatly reduce the appearance of your stomach fat and get you started on the road to a healthy body. The trick is patience. Getting in shape takes time and it is important to tone your whole body. If you just focus on your stomach, your stomach fat will simply reappear somewhere else on your body. That said, here are 5 tips to remove stomach fat you can use today:

1. Start an abdominal workout routine immediately. It is important to exercise your whole body but there is no rule that says you can't focus on one part of your body more than others. Instead of simply lounging in the evening, do crunches or squats while you watch television or listen to music. You don't have to do hundreds of them either to see results.

2. Talk with your doctor about drastically cutting your calorie intake for a few days. By cutting your calorie intake your body will start to burn its fat stores in an attempt to keep your body functioning at its usual energy level. It is imperative, however, that you start to increase your calorie intake over time. Remember, the goal is to be healthy!

3. Cut all of the processed foods out of your diet. Instead of choosing snacks from the snack aisle, stock up on fresh fruits and vegetables to snack on when you are between meals. At mealtimes opt for as many raw foods as you can as raw foods are far healthier than cooked foods.

4. Start sitting up straight. Proper posture, especially when you aren't used to it, can reduce the appearance of stomach fat (slouching can double the amount of flab that falls over your waistline). What's more, it takes energy to hold yourself upright all day long--energy that burns calories! It's a low burning energy, but it burns calories nonetheless!

5. Drink enough water! Instead of quenching your thirst with juice, soda, coffee or teas--opt for water. Water is essential to keeping your body healthy and your organs functioning properly. Water will help you sweat out your toxins instead of storing them as fat. What's more, water has zero calories so by cutting out the other beverages and replacing them with water, you'll be cutting your calorie intake by hundreds of calories a day!

These are just five tips that you can use to remove stomach fat today. By doing some research and talking to your doctor you will easily be able to come up with even more ways to get your body in shape, be healthy and reduce your "flab." Make sure you run any decisions about your body by your primary care physician. Together the two of you can put together a complete plan to keep the body fat at bay.

SQL Server, Drop All Tables in Database Quickly

SELECT name INTO #tables from sys.objects where type = 'U'

while (SELECT count(1) FROM #tables)> 0

begin

declare @sql varchar(max)

declare @tbl varchar(255)

SELECT top 1 @tbl = name FROM #tables

SET @sql = ‘drop table [' + @tbl + ']‘

exec(@sql)

DELETE FROM #tables where name = @tbl

end

DROP TABLE #tables;

Page Life Cycle Events

Mainly four type of life cycle in c#
1)page load
2)page init
3)page pre render
4)page unload

Page_Init
The server controls are loaded and initialized from the Web form's view state. This is the first step in a Web form's life cycle.
Page_Load
The server controls are loaded in the page object. View state information is available at this point, so this is where you put code to change control settings or display text on the page.
Page_PreRender
The application is about to render the page object.
Page_Unload
The page is unloaded from memory.
Page_Disposed
The page object is released from memory. This is the last event in the life of a page object.
Page_Error
An unhandled exception occurs.
Page_AbortTransaction
A transaction is aborted.
Page_CommitTransaction
A transaction is accepted.
Page_DataBinding
A server control on the page binds to a data source.
Process Request Method finally renders HTML Page

LINQ

Disadvantages of LINQ over Stored Procedures

1. Network traffic: SP's need only serialize SP-name and argument data over the wire while LINQ sends the entire query. This can get really bad if the queries are very complex. However, LINQ's abstraction allows Microsoft to improve this over time.


2. Less flexible: SP's can take full advantage of a database's featureset. LINQ tends to be more generic in it's support. This is common in any kind of language abstraction (e.g. C# vs assembler).


3. Recompiling:If you need to make changes to the way you do data access, you need to recompile, version, and redeploy your assembly. SP's can sometimes allow a DBA to tune the data access routine without a need to redeploy anything.

Advantages of LINQ over Stored Procedures

1. Type safety:
   


2. Abstraction: This is especially true with LINQ-to-Entities. This abstraction also allows the framework to add additional improvements that you can easily take advantage of. PLINQ is an example of adding multi-threading support to LINQ. Code changes are minimal to add this support. It would be MUCH harder to do this data access code that simply calls sprocs.


3. Debugging support: I can use any .NET debugger to debug the queries. With SP's, you cannot easily debug the SQL and that experience is largely tied to your database vendor (MS SQL Server provides a query analyzer, but often that isn't enough).


4. Vendor agnostic: LINQ works with lots of databases and the number of supported databases will only increase. SP's are not always portable between databases, either because of varying syntax or feature support (if the database supports SP's at all).


5. Deployment: Others have mentioned this already, but it's easier to deploy a single assembly than to deploy a set of SP's. This also ties in with #4.


6. Easier: You don't have to learn T-SQL to do data access, nor do you have to learn the data access API (e.g. ADO.NET) necessary for calling the SP's. This is related to #3 and #4.

Difference between ADO.net Dataset and ADO Recordset

Dataset:

1.With dataset you can retreive data from two different databases and merge them into one dataset.

2.All representations is done in xml.

3.Dataset can be transmitted on HTTP.

Recordset:

1.With recordset you cannot retreive data from two different databases and merge them into one recordset.

2.All representations is done using COM.

3.Recordset cannot be transmitted on HTTP

The out and ref Paramerter in C#

The out and the ref parameters are used to return values in the same variables, that you pass an an argument of a method. These both parameters are very useful when your method needs to return more than one values.

In this article, I will explain how do you use these parameters in your C# applications.

The out Parameter

The out parameter can be used to return the values in the same variable passed as a parameter of the method. Any changes made to the parameter will be reflected in the variable.

public class mathClass
{
public static int TestOut(out int iVal1, out int iVal2)
{
iVal1 = 10;
iVal2 = 20;
return 0;
}
public static void Main()
{
int i, j; // variable need not be initialized
Console.WriteLine(TestOut(out i, out j));
Console.WriteLine(i);
Console.WriteLine(j);
}
}

The ref parameter

The ref keyword on a method parameter causes a method to refer to the same variable that was passed as an input parameter for the same method. If you do any changes to the variable, they will be reflected in the variable.

You can even use ref for more than one method parameters.

namespace TestRefP
{
using System;
public class myClass
{
public static void RefTest(ref int iVal1 )
{
iVal1 += 2;
}
public static void Main()
{
int i; // variable need to be initialized
i = 3;
RefTest(ref i );
Console.WriteLine(i);
}
}
}

Joins In Sql Server

Table


Query
Inner Join

select * from car as a inner join
Dept as b On a.CarId=b.id

Outer Join -Full

select * from Emp as a full outer join
Dept as b On a.Id=b.id

Left
select * from Emp as a left outer join
Dept as b On a.Id=b.id

Right
select * from Emp as a right outer join
Dept as b On a.Id=b.id

Result

Interview question

How to Insert Values into an Identity Column in SQL Server?
SET IDENTITY_INSERT IdentityTable ON

INSERT IdentityTable(TheIdentity, TheValue)
VALUES (3, 'First Row')

SET IDENTITY_INSERT IdentityTable OFF

How to clone table structure to another table?

1. select top 1 into [NewTable] from [ExistingTable] where ....
or
2. select top 0 into [NewTable] from [ExistingTable]
insert [NewTable] select * from [ExistingTable] where ...

What is Webparts?

Write a syntax for the Uesr Defined Function And Stored Procedure[Delete the data from some Table.]?

What is WebGarden & WebForm?

How to Maintain the CheckBox State in the GridView Paging?

What is Static Constructor?

Interface Vs Abstract ?

Sealed Class?

Serialized Class?

State Management?

Syntax for RAISERROR in Sql Server.?

how to Debug Client (java) Script in visual studio 2005?

Go to IE Internet option and select the Advance Tab option and uncheck the Disable script Debugging(Internet Explore) (REF above image).
and Run your Application, then click the ALT+CTRL+N u got the New Window that name is called Script Explore you will get the file , you click the file it will open, u can use click the f9 function Key.then run your application .

caling javascript from codebehind file while using Ajax .

CloseWindow = "alert('sundar')";//we have to call javascript function also.
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CloseWindow", CloseWindow,true);

following code should be work in the page load time only

Page.RegisterClientScriptBlock("sundar", "")
Page.RegisterStartupScript("sundar", "");

Javascript Char Codes (Key Codes)

Javascript Char Codes (Key Codes)

Summary

Javascript is often used on the browser client side to perform simple tasks that would otherwise require a full postback to the server. Many of those simple tasks involve processing text or characters entered into a form element on a web page, and it is often necessary to know the javascript keycode associated with a character. Here is a reference.

Key Pressed Javascript Key Code backspace 8 tab 9 enter 13 shift 16 ctrl 17 alt 18 pause/break 19 caps lock 20 escape 27 page up 33 page down 34 end 35 home 36 left arrow 37 up arrow 38 right arrow 39 down arrow 40 insert 45 delete 46 0 48 1 49 2 50 3 51 4 52 5 53 6 54 7 55 8 56 9 57 a 65 b 66 c 67 d 68 e 69 f 70 g 71 h 72 i 73 j 74 k 75 l 76 m 77 n 78 o 79 p 80 q 81 r 82 s 83 t 84 u 85 v 86 w 87 x 88 y 89 z 90 left window key 91 right window key 92 select key 93 numpad 0 96 numpad 1 97 numpad 2 98 numpad 3 99 numpad 4 100 numpad 5 101 numpad 6 102 numpad 7 103 numpad 8 104 numpad 9 105 multiply 106 add 107 subtract 109 decimal point 110 divide 111 f1 112 f2 113 f3 114 f4 115 f5 116 f6 117 f7 118 f8 119 f9 120 f10 121 f11 122 f12 123 num lock 144 scroll lock 145 semi-colon 186 equal sign 187 comma 188 dash 189 period 190 forward slash 191 grave accent 192 open bracket 219 back slash 220 close braket 221 single quote 222