Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72602 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / ghanshyam vrema
1. SP may Return a value but Trigger Not,
2. In SP you can pass parameter But in trigger you can't
3. we explicitly call the Sp when Trigger are implicitly
fired
4. you can write a sp in Trigger but in a Trigger you cant
write SP.
5. Trigger written on an individual Table or View where SP
is written for an Database
| Is This Answer Correct ? | 75 Yes | 43 No |
Post New Answer View All Answers
application server is slow what may be the problem
What is SubQuery in SQL Server 2008
what is the difference between a primary key and a unique key? : Sql server database administration
What is transact-sql language?
What is model database in sql server?
What happens if ntwdblib.dll is missing on your machine?
In what sequence sql statement is processed?
What are entities and relationships?
What is the exact numeric data type in sql?
Can we linked SharePoint to a SQL database?
What information is maintained within the msdb database?
How will you monitor replication latency in transactional replication? : sql server replication
Can you index views?
What is sub-query in sql server? Explain its properties.
What are character string data types in ms sql server?
