triggers are applied on a particular table /views stored procedures are a

Wht is the difference between stored procedure and trigger

Question Posted / hytham raju

Answer Posted / hytham raju

triggers are applied on a particular table /views
stored procedures are applied for particular data base

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to recompile stored procedure at run time?

1005

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1087

What is key set driven?

893

What are pages and extents? : SQL Server Architecture

957

‘Order by’ is not allowed in a view how can you sort information from a view?

1020

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

837

Do you know what are pages and extents? : SQL Server Architecture

942

How important do you consider cursors or while loops for a transactional database?

908

What is triggers and stored procedures?

889

What are trace flags and mention a few common trace flags used with sql server?

1036

What are the restrictions applicable while creating views? : SQL Server Architecture

979

Define normalisation?

1061

What are the advantages of user-defined functions over stored procedures in sql server?

960

What is normalization of database? What are its benefits?

961

What happens to a trigger with multiple affected rows?

865