My reason for creating this thread is to understand from people around here how not to misbehave (of any kind, lile rudeness, arrogant behavior, some form of misconduct etc.) during an interview. And also the way I am putting forward my answers to their questions.

Hope no one mind.

Ok, I appeared for an interview today, technical questions were fired to me like canon balls fired by Pirates of Caribbean.

There were 2 questions that bothered me the most. (and the way reacted to my answers after)

1) In my resume, I have mentioned T-SQL (Transact SQL) and MS SQL Server 2000. No where in my resume SQL server 2005 is mentioned. They asked me how T-SQL is different from stored procedure?

Ans) Stored procedures are subroutines created within the database itself and are available to all the applications accessing this relational database.

T-SQL is a MS' extension to SQL language. This language is a base to access the resources of any MS SQL Server. All applications send T-SQL statements to server in order to establish some kind of communication with it.
Am I wrong somewhere or totally wrong?

Note: in my resume, I have highlighted some skills which are C#/VB.Net, ASP.Net, ADO.Net, XML/XSLT, and MS SQL Server 2000 (not T-SQL).

Reaction) While SP are parsed within the database and can be used in any version of SQL server, TSQL are MS SQL Server 2005 only feature, and when we write any TSQL in it, they are compiled in a DLL?

So Harsh, it seems that you know nothing except for the ones you have highlighted!! (lady :giggles
2) How will you sort an arraylist of, say, integers, and display them?

Ans) I can either call the Sort() method of this array or arraylist.

Reaction) Any other way?

Ans) We can create a SortedList out of this Arraylist, which will automatically sort them in an ascending order.

Or we can specify a function implementing an IComparable and IComparer interfaces and perform necessary action.

Reaction) Automatically sorted ? Is it possible? Have you ever used Collections in your life?
Am I wrong again anywhere? These were the 2 I could remember. There were numerous instances of such classes.. aha one more!

Q) What are classes and structures?

Ans) Both are container types and so they can contain other types as members.

Structures are value type and uses stack allocation while classes are reference type (Reaction ) and uses heap allocation....

Reaction: We think you are confusing 2 things.
The only difference today, I didn't argued with the interviewers' today and remain silent nodding to their answers and made myself stupid.

It is not that I was brilliant at answering questions. I couldn't write 1 query for a sample table they showed me, out of 2. But then I could not recall if it was a blunder from my side!!!

Man, I want to stab myself to death today.