Answer Posted / ram

Stored Procedures are called by the programmer wherever it
wants to fire but triggers fired automatically when
insert,delete,update occured. And triggers can be
implemented to tables & views only where as s.p used in the
database independently

Give main differences between "Truncate" and "Delete".

1087

---

Write a program using SQL queries to find a unique entry in a table.

988

---

When would you use the stored procedures or functions?

998

---

What is database black box testing?

1029

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

949

---

How much does sql server 2016 cost?

1054

---

What is enhanced database mirroring in sql server 2008?

967

---

Define indexes?

1037

---

What is the purpose of grouping data in a report?

962

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

959

---

What is the difference between dbcc indexdefrag and dbcc reindex?

981

---

Differentiate between a having clause and a where clause.

962

---

explain databases and sql server databases architecture? : Sql server database administration

957

---

what are the reporting service components in SSRS?

163

---

What is a non-clustered index?

991

---