执行sql语句给外部变量赋值

 declare @siteArray nvarchar(max) ---存储用户的所有站点
e g(hz a17140602 declare @guid nvarchar(max)         ---存储站点的所有产品ITPUB个人空间#`({6B!V"zm?
set  @siteArray=''
K;OuP!T*_-_f;[ J17140602
Xq6oL;}Y Y6~|Q;t17140602 --设置用户的所有站点ITPUB个人空间G.z3^B]L#T K.R9K
selectITPUB个人空间 g4I:O!A4^$W
    @siteArray=@siteArray+''''+convert(nvarchar(500),Site.ID)+''','ITPUB个人空间3YT:Z.Q*K+}
from SiteUserITPUB个人空间K,m6~7L_.]/%|
    left join Site on Site.ID=SiteUser.SiteID
T!|(e5/LI9oX&k17140602      where SiteUser.UserID=570ITPUB个人空间&m)Xc%{'_V8]0S
    and SiteID IN (select ID from Site where State<>0)
(`3oVXT17140602     set @siteArray=substring(@siteArray,1,len(@siteArray)-1)
s#U'[`&D/t17140602 select @siteArrayITPUB个人空间H'DM"BYh

W X}3v C5x9N6vOO0G H17140602 declare @str nvarchar(max)
"Xd,_3c.[N17140602 set @guid=''ITPUB个人空间&r|"F+r*Q6X3^

9vOE:a^ Z"`T"m6Y PK17140602 set @str ='selectITPUB个人空间 u3b N7kP
    @temp=@temp + convert(nvarchar(500),Products.guid)
1pyH6bX.zg)s)cu,N17140602 from ProductsITPUB个人空间:VG+lVB{
    where siteID in ('+@siteArray+')'ITPUB个人空间iE7Gm8p�oM9J`
ITPUB个人空间)}f5E)bm
exec sp_executesql @str,N'@temp nvarchar(max) output',@guid outputITPUB个人空间*jGo zrG+}]J
ITPUB个人空间]:GA&w/V;TV-^W
select @guid