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

__________________
MSB

start by using BOOKS ONLINE, it has great examples.

Jaime E. Maccou

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

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