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
 
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 :)
 
Back
Top