这段SQL报错﹐如何改,请帮忙?

Question

CREATE proc TblRecordCount(@Table varchar(50)) 
as
BEGIN
    DECLARE @RecordCount int
    DEClARE @s nvarchar(1000)
    set @s=N'select @RecordCount=COUNT(*) FROM '+@Table
    exec sp_executesql @s,N'@RecordCount int out',@RecordCount out
    
    RETURN @RecordCount
END

Answer 1

谢谢lsxaa(小李铅笔刀),我結貼了.

Answer 2

lsxaa(小李铅笔刀)set @s=N'select @RecordCount=COUNT(*) FROM '+@Table你这样写对吗？

Answer 3

请问,此问题不能用Function解决吗? select name,TblRecordCount(name) from sysobjects,如果用Procedure得不到解决阿.