CREATE Procedure wareByCategory.docVIP

CREATE Procedure wareByCategory @CategoryID int AS SELECT wareID, ModelName, SalePrice FROM ware WHERE typeID = @CategoryID ORDER BY ModelName, ModelNumber GO CREATE Procedure UserInfo @UserID int, @UserName nvarchar(50) OUTPUT, @Password nvarchar(50) OUTPUT, @Name nvarchar(50) OUTPUT, @Email nvarchar(50) OUTPUT, @IDCardNumber nvarchar(50) OUTPUT, @TelephoneNumber nvarchar(50) OUTPUT AS SELECT @UserName = UserName, @Password = Password, @Name = Name, @Email = Email, @IDCardNu