Answer / reva ram sahu

constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.

Answer / surya

Constraints are used to provide the scope to table data...
they are..
Primary key
unique key
not null
check
foriegn key
default..

Answer / anand

primary constraint
check constraint
notnull constraint
foreign key constraint

What are logical/boolean operations in ms sql server?

1 Answers  

---

What is bcp? When does it used?

1 Answers  

---

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

---

Explain the disadvantages of cursors?

1 Answers  

---

What should be the fill factor for indexes created on tables? : sql server database administration

1 Answers  

---

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

---

What are the features of Embedded SQL

1 Answers   HCL,

---

What is sql server database?

1 Answers  

---

Explain about system stored procedure?

1 Answers  

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1 Answers  

---

How to rebuild all indexes on a single table?

1 Answers  

---

What is auditing in sql server?

1 Answers  

---