Answer Posted / surya

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

What is a covered index?

889

---

How to enter unicode character string literals in ms sql server?

1015

---

What are triggers in ms sql server?

1097

---

Define full outer join in sql server joins?

909

---

Explain log shipping and mention its advantages.

988

---

What are the different types of backups that exist?

1108

---

What is the New in SQL server 2008?

916

---

How to create function with parameter in sql server?

1034

---

Can you use order by when defining a view?

914

---

What is the most common trace flags used with sql server?

961

---

what is database replicaion? : Sql server database administration

1100

---

How to create stored procedures with parameters in ms sql server?

987

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

890

---

User wants only to display only pdf as export option in report manager. How to achieve this?

247

---

What is the difference between row_number and dense_rank?

825

---