SQL入门教程中对存储过程的简易介绍

简单认识存储过程 CREATE PROCEDURE usp_ChangePassword ( @cus_id nchar(5), @cus_oldpwd nvarchar(6), @cus_newpwd nvarchar(6), @myerror int output ) AS SET NOCOUNT ON set @myerror = 0 declare @temp_pwd nvarchar(6) select @temp_pwd = password from customers where customerid= @cus_id