stored procedure for inserting a field in to database

[sevenbellls]

i want stored procedure in sqlsever for inserting a field to database

thnks & rgds
sevenbellls

 

[Pace]

Hi there,

Here is a basic example;

Create Procedue usp_MyInsert
(
@insertID UNIQUEIDENTIFIER,
@insertName VARCHAR(50),
@insDescrip TEXT,
)
AS
INSERT INTO myTable
(insertID, insertName, insDescription, LastUpdateDate)
VALUES (@insertID, @insertName, @insDescrip, GETDATE())

If you need more help, just ask