Proc_UpdateUserInfo.txt
上传用户:gooyliu
上传日期:2018-09-29
资源大小:5816k
文件大小:0k
源码类别:

.net编程

开发平台:

C#

  1. CREATE PROC Proc_UpdateUserInfo
  2.   @userID         NVARCHAR(50),
  3.   @userDepartment NVARCHAR(50),
  4.   @userAddress    NVARCHAR(50),
  5.   @userPhone      NVARCHAR(50)
  6. AS
  7.   UPDATE Users SET userDepartment=@userDepartment,
  8.                    userAddress=@userAddress,
  9.                    userPhone=@userPhone
  10.                WHERE userID=@userID