Answer Posted / shankar k

Constraint are used to table columns validations.
there are some constraints.

Primary key,
Foreign Key,
Not Null,
Check,
Unique Key,
default

What are different types of raid configurations? : SQL Server Architecture

568

---

How to create a simple user defined function in ms sql server?

543

---

How to reaname table name without using sp_Rename in sql server..?

527

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

505

---

Do you know what are acid properties?

566

---

---

Mention the differences between substr and charindex in sql server.

516

---

How will you add a dimension to cube? : sql server analysis services, ssas

551

---

How to integrate the ssrs reports in application?

540

---

What are synonyms?

523

---

Explain about analysis services?

573

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

592

---

What are system databases into sql server (2005/2008)?

580

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

547

---

Define cursor locking

550

---

Explain insert into select statement?

523

---