>Can anybody explain how I can use a SQL Server stored procedure to insert a record into a SQL table? I am looking at the help file, and it kind of explains it, but it doesn't show how to pass in parameters.
>

create procedure EventList_Insert
(
    @Code varchar (16),
    @ShortDesc varchar (20),
    @Description varchar (50),
    @IsInternal int,
    @IsTicketLastUpdated int
) 
AS

SET NOCOUNT ON

INSERT INTO EventList 
(
    Code,
    ShortDesc,
    Description,
    IsInternal,
    IsTicketLastUpdated
)
VALUES
(
    @Code,
    @ShortDesc,
    @Description,
    @IsInternal,
    @IsTicketLastUpdated
)