Answer Posted / sivanagireddy.k

constraints nothing but condition on column in the table by using constraint checking process or validation pprocess has been done.

constraints are 6 tyes
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key

types of level in constraints

column level
table level

send ur queries to this mail id rsivanagireddy@gmail.com

What is the openxml statement in sql server?

1012

---

explain how to create a new schema in a database? : Sql server database administration

1060

---

What is standby servers? Explain types of standby servers.

930

---

What do you understand by mirroring?

952

---

What is a trigger what are the advantages of trigger?

916

---

What are the new features of sql server 2012 reporting service?

123

---

What is sql server schema compare? How we can compare two database schemas?

962

---

How to include text values in sql statements?

984

---

How do you debug a procedure in sql server?

893

---

What is ms sql server service broker?

935

---

What is proper subset of candidate key?

947

---

Can we shrink data file in sql server?

1000

---

Explain cross join or cartesian product in sql?

842

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2094

---

How do I view a script in sql server?

980

---