Return to Snippet

Revision: 27848
at June 25, 2010 04:39 by vedgiee


Initial Code
CREATE PROCEDURE [dbo].[login]
(
	@username varchar(50),
	@password varchar(50)
)

AS

SELECT *  FROM tblUsers WHERE userName = @username AND userPass = @password

RETURN @@ROWCOUNT

Initial URL


Initial Description


Initial Title
MS SQL Store Procedure

Initial Tags


Initial Language
SQL