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 recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1004

---

Do you know what are the reporting services components?

976

---

Tell me what is the stuff and how does it differ from the replace function?

983

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1210

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

---

What is the difference between migration and upgradation in sql server?

1099

---

What are logical/boolean operations in ms sql server?

1050

---

Define full outer join?

962

---

What different steps will a sql server developer take to secure sql server?

999

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

935

---

What is the security principal at the database level that represents your session?

945

---

What is bulkcopy in sql?

948

---

What is ems sql management studio? : sql server management studio

1114

---

When I delete any data from a table, does the sql server reduce the size of that table?

1021

---

How to retrieve field values using mssql_result()?

1317

---