Answer Posted / kannan g

Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null

What is the maximum size of a dimension? : sql server analysis services, ssas

558

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

566

---

Explain how to maintain a fill factor in existing indexes?

526

---

Which table keeps the locking information?

519

---

How to connect to a sql server using odbc_connect()?

616

---

---

How to delete multiple rows with one delete statement in ms sql server?

515

---

why would you use sql agent? : Sql server database administration

523

---

What are character string data types in ms sql server?

628

---

How to provide values to stored procedure parameters in ms sql server?

529

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1848

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

529

---

How to Check if table exists in sql server?

617

---

What is a cursor, index in sql?

573

---

can an order by clause be used in a creation of a view?

693

---

What is autocommit mode in sql server?

541

---