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.

How to specify the collation for a character data type in ms sql server?

962

---

what are acid properties? : Sql server database administration

926

---

Can we insert data into a view?

1061

---

How to define the name and server for a new dsn?

1005

---

Explain trigger and trigger types?

905

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2529

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1850

---

Explain primary key?

895

---

Which joins are sql server default?

936

---

How to rebuild all indexes on a single table?

991

---

What is difference between order by and group by?

953

---

What is the current limitation of the size of SQL Azure DB?

124

---

What are extended events in sql server?

903

---

Explain “not null constraint” in sql server?

952

---

What are the advantages of using third-party tools?

916

---