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 string pool in c#?

1055

---

Is there an equivalent to the instanceof operator in visual j++?

1008

---

What is final keyword in c#?

1056

---

What is session management in c#?

1014

---

What is the use of console?

945

---

What is dynamic dispatch?

1009

---

Can we inherit singleton class in c#?

932

---

Why do we need generics in c#?

982

---

What are the fundamental differences between value types and reference types?

1113

---

What exception can an overridden method throw in comparison with the method it is overriding?

914

---

What types of object can I throw as exceptions?

979

---

What is before string in c#?

975

---

How do I declare a pure virtual function in c#?

1035

---

What is session c#?

1017

---

What is difference between tostring() vs convert.tostring() vs (string) cast

1092

---