Answer Posted / ramesh

stored procedure:

Group of sql statements compiled into single execution plan.

create procedure sp_procedurename
as
begin
begin transaction
select * from table

if @@error=null
commit

else
rollback

end

Trigger
--------

Trigger is a set of sql queries which fire when an event
occurs(delete,update,insert).

in 2005 DDL TRIGGER INTRUDUCED.

What is temporary table in sql server? Why we use temp table?

952

---

What is isnull() operator?

1040

---

Where to find ntwdblib.dll version 2000.80.194.0?

962

---

What is the difference between index seek vs. Index scan?

1023

---

Explain a join?

1071

---

what do you understand by change data capture?

1024

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

965

---

How you provide security to cube? : sql server analysis services, ssas

964

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1073

---

How many categories of data types used by sql server?

1020

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1015

---

How to use subqueries with the in operators in ms sql server?

1074

---

Where are sql server user names and passwords stored in sql server?

1093

---

What is the difference between Clustered and Non-Clustered Index?

1059

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

995

---