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...........

What are the advantages of using stored procedures in sql server?

955

---

Can we insert data into a view?

1065

---

What is the difference between primary key and unique constraints?

904

---

What is the difference between the 2 operating modes of database mirroring?

1059

---

How can you know if the row fetched from cursor is still valid in underlying table?

956

---

How many types of triggers in sql server?

972

---

What are rest-style architecture's?

170

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

924

---

What is database architecture? : SQL Server Architecture

976

---

What is the contrast amongst drop and truncate?

981

---

What are the options which must be set to allow the usage of optimistic models?

917

---

Does sql server 2016 have ssms?

913

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5873

---

What is difference between commit and rollback when used in transactions?

909

---

Can group by be used without aggregate functions?

857

---