Answer Posted / vijaya

Constraints are rool of data integrity.

Types of Constraints are:
1)Not Null
2)Unique
3)Primary Key
4)Check
5)References.

Is sql server a database?

531

---

How can change procedure in sql server?

517

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

629

---

Explain four layers of abstraction microsoft architectured?

120

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

532

---

---

When would you use a before or after trigger?

486

---

How does recursive cte works in sql server?

524

---

How to defragment table indexes?

546

---

Can we hide the definition of a stored procedure from a use?

651

---

between cast and convert which function would you prefer and why?

532

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

510

---

How do I view a trc file?

503

---

can an automatic recovery be initiated by a user? : Sql server administration

513

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1435

---

What are the differences between ms sql server & oracle?

519

---