Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72585 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / veerababu
Stored Procedure is a method.
Trigger is a Procedure.
Stored Procedure a specific CALL or EXECUTE has be used.
Trigger is automatically execute some specific events occure in table/views.
Stored Procedure return a Value.
Trigger is not return a value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain having clause and where clause?
What are the advantages of using third-party tools?
Can we use pragma autonomous_transaction in trigger?
How to edit table in sql server 2017?
Why I have to use stored procedures?
Which rendering formats are affected by the pagesize properties?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
Explain the microsoft sql server delete command? : SQL Server Architecture
what is the difference between Tabular and Matrix report?
What is difference between global temporary tables and local temporary tables?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What is log shipping?
Explain ranking functions?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Define primary key?
