写个简单的存储过程还出现(1 行受影响)谁能帮忙下

[dt119]

create proc insert_book
@id int,@name nvarchar,@price money
as
insert into book(编号,书名,价格)values(@id,@name,@price)
go


exec insert_book'4','ddd',$55

执行提示(1 行受影响)

[wzy_love_sly]

create proc insert_book
@id int,@name nvarchar(50),@price money
as
begin
set nocount on
insert into book(编号,书名,价格)values(@id,@name,@price)
set nocount off
end

[wzy_love_sly]

nvarchar(50)加长度，加set nocount on

[sword_88]

[Quote=引用 1 楼 wzy_love_sly 的回复:]
SQL codecreate proc insert_book
@id int,@name nvarchar(50),@price money
as
begin
set nocount on
insert into book(编号,书名,价格)values(@id,@name,@price)
set nocount off
end
[/Quote]

[tigerjl]

路过学习~~~~