Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is the difference between stored procedure and trigger
- 6 Answers
- 14847 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
How to download microsoft sql server 2005 express edition?
How many primary keys are possible in a table?
How many replicas are maintained for each sql azure db?
Find columns used in stored procedure?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
How to get a list of columns using the "sys.columns" view in ms sql server?
How to rebuild the master database?
How optimize sql query with multiple joins in sql server?
What is database mirroring?
Can I save my report as html, excel or word? : sql server management studio
What are the disadvantages of indexes?
How to convert numeric expression data types by assignment operations?
Tell me the phases a transaction has to undergo?
What is a linked server in sql server?
What is local temp table?
