Answer Posted / yashwanth

constraints are the rules enforced on data columns on a
table
use:constraints are used to limit the type of data that
can go in to a table

there are some constraints
a primarykey constraint
a unquekey constraint
a foreinkey constraint
a check constraint
a not null constraint
a default constraint

How to create and drop temp table in sql server?

1009

---

Define Joins?

982

---

What is the difference between a function and a trigger?

1021

---

Which is faster statement or preparedstatement?

898

---

What are the advantages of stored procedure in sql server?

843

---

What is user-defined functions? What are the types of user-defined functions that can be created?

990

---

How many primary keys are possible in a table?

881

---

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

900

---

What are statistics?

960

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1011

---

What is clustered vs nonclustered index?

894

---

What is 4nf in normalization form?

961

---

Explain logical operators in sql server?

1044

---

Is null in sql server?

954

---

What do you mean by normalisation?

976

---