Answer Posted / amar

triggers is a block of code where is fired to do something action for insertion or delation of varioue t- sql statement........ where triggers are automatically fired.........

stored procedure is a predefined data types which is stored in a database............ stored procedure has to fire...........

How to retrieve error messages using odbc_errormsg()?

1101

---

How do you open a cluster administrator?

1094

---

How does Report Builder support Analysis Services cubes?

158

---

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

141

---

How sql server executes a statement with nested subqueries?

1087

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1115

---

What is the query and subquery?

1119

---

Explain about service Broker functions?

1084

---

Can group by and orderby be used together?

1063

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1020

---

How to access the inserted record of an event?

1105

---

How can you find out which stored procedures are recompiling?

948

---

Do you know what are different types of replication in sql server?

1151

---

What is the difference between locking and multi-versioning?

1033

---

Define tool Manage Statistics in SQL Server 2000 query ?

1163

---