Answer Posted / neeraj sharma

When we fire the trigger then the data goes to temporary
tables. when we execute insert, delete, update trigger the
the data goes to temporary tables. these temporary tables
are called as magic tables. There to types of magic tables:
1. Inserted
2. Updated

What is mean by candidate key?

949

---

what do you understand by change data capture?

940

---

how to invoke a trigger on demand? : Sql server database administration

1002

---

What are ddl (data definition language) statements for tables in ms sql server?

1030

---

What is the user of Primary key?

926

---

Can binary strings be used in arithmetical operations?

887

---

Difference between uniqe index and uniqe constraint?

918

---

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

910

---

How is SQL Azure different than SQL server?

223

---

How do I edit a procedure in sql server?

901

---

What do you mean by stored techniques? How would we use it?

980

---

What is the difference between coalesce() & isnull()?

1050

---

Can the query output be sorted by multiple columns in ms sql server?

937

---

What are the character string functions supported by sql server 2005?

937

---

What is the difference between a function and a stored procedure?

1007

---