Answer Posted / haritha

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.

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1030

---

what is the system function to get current user's user id? : Sql server database administration

1010

---

What number sorts of privileges are accessible in sql?

1037

---

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

1143

---

What is the datatype of rowid?

928

---

What is the contrast amongst drop and truncate?

1034

---

Sql server reporting services vs. Crystal reports.

134

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1012

---

Can a database be shrunk with users active?

1141

---

What is the difference between join and inner join?

1020

---

What is a system database and what is a user database?

1090

---

What is stored procedures?

1051

---

Where the sql logs gets stored? : sql server database administration

971

---

Which is the latest version of sql server and when it is released?

1115

---

What are logical/boolean operations in ms sql server?

1051

---