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
How do you make a trace?
How to check if stored procedure is running in sql server?
can SSRS reports Cache results?
What area unit the various kinds of info compression introduced in sql server 2008?
What are the diifferences between the ms sql server vs mysql?
What is difference between group by and having?
How do I run a trace in sql server?
What is bcnf normalization form?
What is triggers in ms sql server?
how can you check the level of fragmentation on a table? : Sql server administration
Can you explain what are various ways to enhance the ssrs report?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Where are SQL server users names and passwords are stored in sql server?
Explain how dts is used to extract, transform and consolidate data?
how you can list all the tables in a database?
