CREATE Procedure wareByCategory.docVIP

  • 2
  • 0
  • 约5.7千字
  • 约 9页
  • 2016-12-03 发布于河南
  • 举报
CREATE Procedure wareByCategory

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

文档评论(0)

1亿VIP精品文档

相关文档