Answer Posted / murugavel

1) char datatype is used to store fixed length character
value & varchar is used to store variable length character
value.

2) Composite Key: combination of multiple fields will
produce the uniqeness is called composite key.

Candidate Key: A field has the ability to become a primary
key is known as candidate key.

3) Temporary Table: This table is only visible to this
session of SQL Server. When I close this session, the table
will be automatically dropped. You can treat this table just
like any other table with a few exceptions. The only real
major one is that you can't have foreign key constraints on
a temporary table.

Derived Table:In very basic terms, a derived table is a
virtual table that's calculated on the fly from a select
statement. The biggest benefit of using derived tables over
using temporary tables is that they require fewer steps, and
everything happens in memory instead of a combination of
memory and disk

4) using DATEDIFF function

Ex: SELECT DATEDIFF(dd,"01 March 2010","18 March 2010")

What is icomparable in c#?

1012

---

Can properties be overloaded in c#?

1016

---

How will you get the different language strings?

992

---

Helo , Help Me , Help Me About : C# Windows Application - Network How To Manage IP Client's Accessiblity To The Internet Share concise Substitute , Minor ISA Server

2005

---

What are the Types of JIT and what is econo-JIT

1307

---

What is an escape sequence? Name some string escape sequences in c#.

981

---

What is default value of decimal c#?

924

---

Define sealed classes in c#?

982

---

Explain About .NET Framework

961

---

What is asenumerable in c#?

954

---

What is parseexact c#?

1065

---

Describe the difference between inline and code behind - which is best?

1204

---

Distinguish between a class and struct?

980

---

What is interface inheritance in c#?

969

---

Give examples for value types?

1002

---