Answer Posted / vikas sinha

1)Stored Procedure can call.but trigger is automatically
invoked when action defined in trigger is done.

2)Stored procedure can not be inactive.but trigger can be
active and inactive.

3)Stored Procedure may or may not reture a value.but
trigger will not return a value.

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2323

---

List all the types of user-defined functions?

994

---

What are difference between Cluster index and Non-Cluster index?

1022

---

What does COMMIT command do?

1008

---

What is normalization? Describe its different types.

1043

---

How to concatenate two binary strings together?

1050

---

What is difference between inner join and join?

986

---

Distinguish between commit and rollback?

901

---

Explain the benefits of user-defined functions?

989

---

Can a synonym name of a table be used instead of a table name in a select statement?

976

---

What is difference between foreign key and unique key?

966

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

996

---

Find columns used in stored procedure?

938

---

what is spatial nonclustered index

945

---

How to loop through result set objects using mssql_fetch_array()?

1021

---