Answer Posted / rajkumar v

SQLserver2000
There are 2 types of triggers

Insted of trigger:
Instead Of Trigger fires an operation instead of performing
user specified operation.


After trigger: After Trigger fires an operation after any
insert,update,delete operations performed on a table.

SQLserver2005

3 types:

1. DML,
2. DDL &
3. CLR

Differentiate between truncate vs delete in mssql?

521

---

What are the different sql server versions?

513

---

Can binary strings be used in arithmetical operations?

522

---

What are the Advantages of using CTE in sql server?

565

---

What is difference between sql and sql server?

538

---

---

What are the components of sql server service broker?

507

---

What is db stored procedure?

465

---

What is trigger and different types of Triggers?

568

---

Explain tablesample?

547

---

Distinguish between commit and rollback?

543

---

How do I edit a procedure in sql server?

546

---

How to bind a view to the schema of the underlying tables?

582

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1419

---

Explain timestamp datatype?

549

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

564

---