Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is the difference between stored procedure and trigger
- 6 Answers
- 14597 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 would you go about developing a ssrs report?
What is the difference between dropping a database and taking a database offline?
How to create a Master database in SQL server ?
What is the difference between substr and charindex in the sql server?
What are the characteristics of modern DBMS?
What are the encryption mechanisms in sql server?
What is cursor in ms sql server?
What is the distinction amongst delete and truncate?
What part does database design plays a role in performance of an sql server-based application?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Explain trigger and trigger types?
What is the difference between push and pull subscription? : sql server replication
What is CTE in SQL
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
which backup strategy you are following at ur company
