Answer Posted / neethu mohanan
stored procedure is used to write queries,if there is an
error in the query it willnot be saved.In this if there is
any parameters first declare it,and then the query is write.
Each stored procedure could have a name.We can create the
stored procedure for any tables in the database.
create database->create table->stored procedure.
format:
(stored procedure name)
(@parameter1 type(size),@parameter2 type(size))
//(query)
insert into tablename values(@parameter1,@parameter2 )
Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
How to concatenate two binary strings together?
What is nolock?
Mention the different types of replication in sql server.
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How many null values we can have in a unique key field in sql server?
Explain about unique identifier data type in sql server?
Do you know what is a linked server in sql server?
What is a select query statement in ms sql server?
What are logical database components? : SQL Server Architecture
What do you mean by sql server agent?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is policy management?
How can delete duplicate records in cte in sql server?
How we can refresh the view?
What is microsoft sql server?