what is diffrent between store procedure and trigger
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
How you can add messages to the nt event log from within a stored procedure?
What is key set driven?
Can you explain different types of joins?
How will you go about resolving deadlocks?
is there a column to which a default can't be bound? : Sql server database administration
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What are the properties of sub-query?
What are the different types of cursor?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
what information is maintained within the msdb database? : Sql server administration
Explain the steps to create and execute a user-defined function in the sql server?
What is a group function explain with an example?
What are the purposes and advantages stored procedure?
What is ddl command?