Help me to DO Stored Procedures

msbsam · October 19th, 2006, 12:03 AM

Hi,
im new 4 sql server. i want to create sored procedures 4 insert,update and delete. so i dont have a knowledge to create those and i dont no how to create and wht's the goodway to do. pls help me. i need it.
thx

MSB

jemacc · October 19th, 2006, 01:58 AM

start by using BOOKS ONLINE, it has great examples.

Jaime E. Maccou

SQLScott · October 19th, 2006, 08:42 AM

Hi MSB,

Stored Procedure syntax is fairly straight forward. The general syntax is as follows:

CREATE PROCEDURE procedurename
    Parameters
AS
BEGIN
   SELECT
   DELETE
   UPDATE
END

Although, I agree with Jamie, Books Online will give you much more information.

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

sgupta · October 23rd, 2006, 01:54 PM

Hi,
I totallly agree with Jaime and Scott.
Here is an example of simple stored Proc for Delete statement,
///to delete particular EmpId from Employee table:
CREATE PROCEDURE DeleteParticularEmployee
@EmpId int
AS
Delete from Employee
where Emp_Id = @EmpId
GO