StoredProcedure

[shlvy]

Hi

I use the next StoredProcedure in Access, Inserts Users to tblUsers:

INSERT INTO tblUsers ( UserName, Password, RetypePassword, Email, Comments )

VALUES (@UserName, @Password, @RetypePassword, @Email,@Comments);

 

How do i have to write it in SQL?

Thank's.

Edited August 26, 2004 by shlvy

[betrl8thanever]

create procedure dbo.PROCEDURE_NAME 
(@UserName varchar(255), @PassWord varchar(255), @RetypePassword varchar(255),
@Emal varchar(255), @Comments varchar(255))
AS
   INSERT INTO tblUsers
    (UserName, PassWord, RetypePassword, Email, Comments)
    VALUES
    (@UserName, @PassWord, @RetypePassword, @Email, @Comments)

GO

 

In this example you are passing the parameters (@) to the stored procedure.

[shlvy]

Hi

Thank you very much.

shlvy.