USE [BBS]
GO
/****** 对象: StoredProcedure [dbo].[User_EditInfo] 脚本日期: 03/31/2010 14:18:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[User_EditInfo]
(@UserName nvarchar(12),
@NickName nvarchar(22),
@Password nvarchar(32),
@Question nvarchar(50),
@Answer nvarchar(50),
@Sex char(8),
@UserHead nvarchar(50),
@Birthday datetime,
@Hobby nvarchar(30),
@UserSign nvarchar(200)
)
as
update dbo.Users
set
NickName=@NickName,
Password=@Password,
Question=@Question,
Answer=@Answer,
where UserName=@UserName