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

How many types of local tables are there in sql server?

976

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2271

---

Can a table have 2 primary keys?

1030

---

How do you create an execution plan?

1000

---

A trigger can reference objects outside the current database? State true or false.

1060

---

Explain what role entity and relationship play in an ER diagram.

1111

---

what is bit datatype? : Sql server database administration

959

---

How do I view a script in sql server?

1083

---

How to set the current database in ms sql server?

1137

---

What are security principals used in sql server 2005?

1036

---

Define ACID properties in a Database?

1102

---

What does it mean to be in union?

979

---

How can a database be repaired?

1032

---

How to download and install the scaled-down database adventureworkslt?

1038

---

What do you mean by table and field in sql?

1062

---