Hi All,

I did a search on stored procedures, but did not find anything on how to write stored procedures to SQL Server. Can someone give me a sample of have it would be done. I am looking for more then a one liner stored procedure.

This is what I think it should be, and have not tried it yet;

TEXT TO lcSqlStr TEXTMERGE NOSHOW
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
)
ENDTEXT

lnReturn = sqlexec(ghConnectionHandle, lcSqlStr

Thanks In advance.