Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is the difference between stored procedure and trigger
- 6 Answers
- 15023 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
What are the different Topologies in which Replication can be configured?
Explain sql server authentication modes?
How can you insert null values in a column while inserting the data?
what is dbcc? : Sql server database administration
How would you add a section to a table?
What is a file group?
How to transfer an existing table from one schema to another schema in ms sql server?
What are sub reports?
how you can list all the tables in a database?
You want to use a perspective in an mdx query. How do you select the perspective?
What are the restrictions while creating batches in sql server?
What factors you will consider calculating the storage requirement for that view?
What is the syntax for encrypting a column in SQL Server?
Is it safe to delete log files?
How is foreign key related to primary key?
