Wht is the difference between stored procedure and trigger
- 6 Answers
- 12965 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / sujit kumar suman
Store Procedure:-It is a pre-compiled object which stored in
current database.It can't execute automatically.
--create store procedure
create proc procedure_name
as
select command
and then
go
--execute procedure
exec procedure_name
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Can we store videos inside the sql server table?
What is sql or structured query language?
What is normalization of database? What are its benefits?
What is a matrix in ssrs?
What gets stored inside msdb database?
How many types of triggers are there?
How much does sql server 2016 cost?
What is key set driven?
What is not null constraint?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How to create a scrollable cursor with the scroll option?
What are the features of Embedded SQL
What is the recovery model?
How to implement service broker?
What is the difference between insensitive and scroll cursor?
