stored procedure for inserting a field in to database

sevenbellls

Member
Joined
Nov 14, 2005
Messages
5
Programming Experience
Beginner
i want stored procedure in sqlsever for inserting a field to database

thnks & rgds
sevenbellls
 

Pace

Well-known member
Joined
Sep 2, 2005
Messages
90
Location
Manchester UK! :)
Programming Experience
1-3
Hi there,

Here is a basic example;

VB.NET:
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 :)
 
Top Bottom