This stored procedure adds a new user to the database. The input parameters include Name, Email and Password.
Definition:CREATE Procedure AddUser ( @Name nvarchar(50), @Email nvarchar(100), @Password nvarchar(20), @UserID int OUTPUT ) AS INSERT INTO Users ( Name, Email, Password ) VALUES ( @Name, @Email, @Password ) SELECT @UserID = @@IdentityDatabase Tables Used:
Users: Each record in the Users table is a unique user identity. The primary key in this table is the UserID identity field.