操作数类型冲突: int 与 ntext 不兼容 20
ifexists(select*fromsysObjectswherename='Longworks_AddLongworks')dropprocLongworks_Ad...
if exists(select * from sysObjects where name='Longworks_AddLongworks')
drop proc Longworks_AddLongworks
go
create proc Longworks_AddLongworks
@lname text output,
@introduction text output,
@cover text output,
@ltype int output,
@tags text output,
@firstshow text output,
@levels text output,
@showtime datetime output,
@clicks int output,
@chapterid int output
as
begin
insert into longWorks values(@lname,@introduction,@cover,@ltype,@tags,@firstshow,@levels,@showtime,@clicks,@chapterid)
end
go
这个是存储过程 表里的类型跟这上写的都一样 有高手说说这是什么问题么 展开
drop proc Longworks_AddLongworks
go
create proc Longworks_AddLongworks
@lname text output,
@introduction text output,
@cover text output,
@ltype int output,
@tags text output,
@firstshow text output,
@levels text output,
@showtime datetime output,
@clicks int output,
@chapterid int output
as
begin
insert into longWorks values(@lname,@introduction,@cover,@ltype,@tags,@firstshow,@levels,@showtime,@clicks,@chapterid)
end
go
这个是存储过程 表里的类型跟这上写的都一样 有高手说说这是什么问题么 展开
1个回答
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
