sql server

Question

am a fresher i know how to create a table,inserting table and deleting table but i don't kn ow how to create a stored procedure please help me ..........

Santosh Yadav · Answer

Suppose you have a table which contains three fields and table name is student. student (table name) and fields are : 1). student_id 2). student_name 3). student_age now you want to create a stored procedure to insert records into table then. Syntax : create proc usp_studentInsert ( @studentid varchar(10), @student_name varchar(50), @student_age varchar(5) ) as insert into student(student_id,student_name,student_age) values(@studentid,@student_name,@studentage); Note : Here, @studentid,@student_name,@studentage are the parameters which you have to pass when you will use this procedure to insert data into table.

Satyapriya Nayak · Answer

The Stored procedure is compiled t-sql program stored as object under the database. It will use the cache execution plan for all the subsequent requests. It can accept parameters. Advantages of the stored procedure It will improve the execution. It will compile once and be stored as an object under the database. The same execution plan will be used for all the subsequent execution. It will reduce the network traffic. It will have only a few bytes of parameters. But the inline query will make more traffic. It will be stored in the SQL Server database and any number of applications which return in the multiple languages/application can utilizes the same stored procedure. The permission can be set to the stored procedure. The stored procedure can be changed the logics without redeploying the application in circumstances. The application developers can work in the front end and the SQL developers they can write the SQL Server. Create table student (sid varchar(50),sname varchar(50),smarks int,saddress varchar (50),year varchar(50)) -------------------------- CREATE PROCEDURE display AS select * from student ----------- CREATE PROCEDURE insert (@sid varchar(50),@sname varchar(50),@smarks int,@saddress varchar (50),@year varchar(50)) AS insert student(sid,sname,smarks,saddress,year) values (@sid,@sname,@smarks,@saddress,@year) --------------------- CREATE PROCEDURE update (@sid varchar(50),@sname varchar(50),@smarks int,@saddress varchar (50),@year varchar(50)) AS update student set sname=@sname,smarks=@smarks,saddress=@saddress,year=@year where sid=@sid ------------- CREATE PROCEDURE delete (@sid varchar(50)) AS delete from student where sid=@sid Refer http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/ http://csharp-station.com/Tutorial/AdoDotNet/Lesson07 http://www.codeproject.com/Articles/179481/Code-First-Stored-Procedures http://www.codeproject.com/Articles/414/Tutorial-on-Extended-Stored-Procedures-for-MS-SQL

Saqi · Answer

Hello manjula , there are plenty of references on youtube which you can see how to use references and forms i strongly recommend you to check first videos with practice. thanks

sql server

Answers (3)