what is diffrent between store procedure and trigger
- 2 Answers
- 5433 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
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the different subsets of sql?
What is an indexed view?
How raid can influence database performance?
When should you use an instead of trigger?
What are the different SQL Server Versions you have worked on?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Is it possible to have clustered index on separate drive from original table location?
what is spatial nonclustered index
What is in place upgrade in sql server?
How to provide default values to function parameters?
Does view occupy space?
What is the difference between for xml raw and for xml auto?
How can I check that whether automatic statistic update is enabled or not?
