CREATE proc tv_share_info
@tvnum varchar(20),
@tvtable varchar(20),
@tvwhere varchar(20),
@tvid varchar(20)
as
declare @sql varchar(100)
set set @sql = ' select top ' + @tvnum + ' * from ' + @tvtable +'where '+@tvwhere+' order by ' + @tvid+ ' desc'
EXEC(@sql)
GOexec tv_share_info '11','dghouseinfo','len(housevideo)>0','num'这样运行老是报错?
@tvnum varchar(20),
@tvtable varchar(20),
@tvwhere varchar(20),
@tvid varchar(20)
as
declare @sql varchar(100)
set set @sql = ' select top ' + @tvnum + ' * from ' + @tvtable +'where '+@tvwhere+' order by ' + @tvid+ ' desc'
EXEC(@sql)
GOexec tv_share_info '11','dghouseinfo','len(housevideo)>0','num'这样运行老是报错?
什么东东?
CREATE proc tv_share_info
@tvnum varchar(20),
@tvtable varchar(20),
@tvwhere varchar(20),
@tvid varchar(20)
as
declare @sql varchar(100)
set @sql = ' select top ' + @tvnum + ' * from ' + @tvtable +'where '+@tvwhere+' order by ' + @tvid+ ' desc'
EXEC(@sql)
GO
CREATE proc tv_share_info
@tvnum varchar(20),
@tvtable varchar(20),
@tvwhere varchar(20),
@tvid varchar(20)
as
declare @sql varchar(100)
set @sql = ' select top ' + @tvnum + ' * from ' + @tvtable +' where '+@tvwhere+' order by ' + @tvid+ ' desc'
EXEC(@sql)
GO