Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is the difference between stored procedure and trigger
- 6 Answers
- 14609 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
Write SQL queries on Self Join and Inner Join.
What are distinctive joins find as a part of sql?
Which are ddl commands?
What is catalog views?
How do I view a stored procedure in sql server query?
What is pessimistic concurrency?
Why do we use stored procedures in sql server?
How to insert and update data into a table with "insert" and "update" statements?
What is the recovery model?
How to use wildcard characters in like operations in ms sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What are different types of roles provided by ssrs?
How you can add messages to the nt event log from within a stored procedure?
Working with TLogs
Can you index views?
