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.

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

953

---

what are candidate key, alternate key and composite key? : Sql server database administration

915

---

Do you know what are acid properties of transaction?

952

---

Can primary key be null?

926

---

What are dml (data manipulation language) statements in ms sql server?

980

---

Do you have any idea about the tcl commands?

958

---

What are distributed partitioned views?

1067

---

How to query multiple tables jointly?

985

---

Is sql server a database?

989

---

What is the architecture of ms sql reporting service?

985

---

What stored by the msdb? : sql server database administration

1001

---

Name three of the features managed by the surface area configuration tool? : sql server security

988

---

Is sql server is free?

975

---

State a few properties of relational databases?

1121

---

Find columns used in stored procedure?

987

---