what is diffrent between store procedure and trigger
- 2 Answers
- 4550 Views
- I also Faced
- E-Mail Answers
Answer Posted / vandana chand
Stored Procedure is the set of SQl statements together in the
data base.
and Trigger is the Special kind of store procedure i.e called
whenever an attempt is to modify the data.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain “not null constraint” in sql server?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is a with(nolock)?
What is the need for group functions in sql?
Which trace flags are enabled in sql server?
What is the difference between migration and upgradation in sql server?
How can you list all the columns in a database?
What are the new features of sql server 2008 r2 reporting service?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is create command?
How many levels of sp nesting is possible?
Define outer join in sql server joins?
How to find the login name linked to a given user name?
How to start and end transact-sql statements?
What happens when unicode strings concatenate with non-unicode strings?
