/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
CREATE PROCEDURE [dbo].[login] ( @username VARCHAR(50), @password VARCHAR(50) ) AS SELECT * FROM tblUsers WHERE userName = @username AND userPass = @password RETURN @@ROWCOUNT