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.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the different normalization forms?
what are the disadvantages of cursors? : Sql server database administration
How to restore performance issues and how to check?
How many databases Microsoft SQL server provides?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Explain about SQL server 2005?
Can group by be used without aggregate functions?
What is entity data services?
What is SQL Azure Data sync?
What are acid properties of transaction?
What are different types of collation sensitivity?
What is the architecture of ms sql reporting service?
Explain system functions or built-in functions? What are different types of system functions?
What do you mean by sql server agent?
Using the customer, and order table in northwind database, please write a query to produce xml?