22,209
社区成员
发帖
与我相关
我的任务
分享
declare @sqlstr nvarchar(3000)
declare @MaterialName nvarchar(50)
declare @RelationCardNo nvarchar(50) set @RelationCardNo='8CN0AS169832529'
set @sqlstr='select rno06,ogb04 from rno_file,ogb_file where rno06='''''+@RelationCardNo+''''' and ogb01=rno01 and rno03=ogb03'
exec('select distinct ogb04 from openquery(MISACHJ,'''+@sqlstr+''')')
declare @sqlstr nvarchar(3000)
declare @MaterialName nvarchar(50)
declare @RelationCardNo nvarchar(50) set @RelationCardNo='8CN0AS169832529'
set @sqlstr='select rno06,ogb04 from rno_file,ogb_file where rno06='''''+@RelationCardNo+''''' and ogb01=rno01 and rno03=ogb03'
declare @t table(ogb04 varchar(100))
insert into @t exec('select distinct ogb04 from openquery(MISACHJ,'''+@sqlstr+''')')
--都在@t里面,想怎么取怎么取