我定义了如下存储过程if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_userinfor_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_userinfor_Update]
GO
------------------------------------
--用途:修改一条记录
--项目名称:CodematicDemo
--说明:
--时间:2009-7-16 13:46:33
------------------------------------
CREATE PROCEDURE UP_userinfor_Update
@U_id int,
@U_name nvarchar(20),
@U_pwd nvarchar(16),
@U_realname nvarchar(10),
@U_pic nvarchar(50),
@U_tel nvarchar(20),
@U_email nvarchar(50),
@U_blog nvarchar(100),
@U_Work nchar(100),
@U_intro nvarchar(1000)
AS
UPDATE [userinfor]
SET
[U_name] = @U_name,
[U_pwd] = @U_pwd,
[U_realname] = @U_realname,
[U_pic] = @U_pic,
[U_tel] = @U_tel,
[U_email] = @U_email,
[U_blog] = @U_blog,
[U_Work] = @U_Work,
[U_intro] = @U_intro
WHERE [U_id]=@U_id
GO
用exec UP_userinfor_Update(1,'yanzi','yanzi','3','4','5','6','7','8','9')测试执行在测试执行的时候老是出现如下问题:'1' 附近有语法错误。不知道为什么,请大家帮忙指点一下
drop procedure [dbo].[UP_userinfor_Update]
GO
------------------------------------
--用途:修改一条记录
--项目名称:CodematicDemo
--说明:
--时间:2009-7-16 13:46:33
------------------------------------
CREATE PROCEDURE UP_userinfor_Update
@U_id int,
@U_name nvarchar(20),
@U_pwd nvarchar(16),
@U_realname nvarchar(10),
@U_pic nvarchar(50),
@U_tel nvarchar(20),
@U_email nvarchar(50),
@U_blog nvarchar(100),
@U_Work nchar(100),
@U_intro nvarchar(1000)
AS
UPDATE [userinfor]
SET
[U_name] = @U_name,
[U_pwd] = @U_pwd,
[U_realname] = @U_realname,
[U_pic] = @U_pic,
[U_tel] = @U_tel,
[U_email] = @U_email,
[U_blog] = @U_blog,
[U_Work] = @U_Work,
[U_intro] = @U_intro
WHERE [U_id]=@U_id
GO
用exec UP_userinfor_Update(1,'yanzi','yanzi','3','4','5','6','7','8','9')测试执行在测试执行的时候老是出现如下问题:'1' 附近有语法错误。不知道为什么,请大家帮忙指点一下
exec UP_userinfor_Update 1,'yanzi','yanzi','3','4','5','6','7','8','9'不用()直接写参数!