文件名称:简单认识存储过程-SQL入门教程
文件大小:14.58MB
文件格式:PPT
更新时间:2024-05-13 18:31:17
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