为什么SQL语句换成存储过程就出错了 大侠来看下
laeep 2005-06-22 12:07:12 我的语句是
NewsSql = "Select top " & NewsListNumberStr & " *,NewsClass.FileExtName as ClassFileExtName,News.FileExtName as NewsFileExtName from News,NewsClass where News.ClassID=NewsClass.ClassID and News.AuditTF=1 and NewsClass.ClassID in (" & AllClassID & ") order by News.ID Desc"
Set RsNewsObj = Conn.Execute(NewsSql)
存储过程是
CREATE Procedure FS_ReFunSelfClass_News
(@num int,
@ClassIDStr varchar(1000))
as
begin transaction
declare @TempStr varchar(1500)
set @TempStr='Select top '+cast(@num as varchar(50))+' *,NewsClass.FileExtName as ClassFileExtName,News.FileExtName as NewsFileExtName from News,NewsClass where News.ClassID=NewsClass.ClassID and News.AuditTF=1 and NewsClass.ClassID in (' +cast(@ClassIDStr as varchar(1000))+') order by News.ID Desc'
exec(@TempStr)
if @@error=0
commit transaction
else
rollback transaction
return
GO
为什么 换了就不能正常运行,大侠来看看怎么改存储过程