ALTER PROCEDURE sp_Spider_GetMinIdByStatus
@TableName varchar(255),
@TheMinId bigint output
AS
set nocount onDeclare @sqlstring varchar(4000)
Set @sqlstring=' select ' + cast(@TheMinId as varchar) + ' =min(Id) from ' +@TableName + ' where Status=0'
Exec (@sqlstring)
set nocount off
go
@TableName varchar(255),
@TheMinId bigint output
AS
set nocount onDeclare @sqlstring varchar(4000)
Set @sqlstring=' select ' + cast(@TheMinId as varchar) + ' =min(Id) from ' +@TableName + ' where Status=0'
Exec (@sqlstring)
set nocount off
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货