CREATE table #MyTempTable AS
(select top 1* from ConverseST_RemindLog a left outer join Member b on
a.MemberID=b.MemberID
where CvsID='45B738C1-FFE8-4CFC-BE23-E191B23EA4AB' order by CrTime desc)
select Content=
'提醒商家 ('+IsNUll(RealName,'')+Convert(varchar(20),CrTime,100)+')'
from ##MyTempTable根据网上找的拼起来的。赋临时表的时候出错了,但是不知道该怎么写
(select top 1* from ConverseST_RemindLog a left outer join Member b on
a.MemberID=b.MemberID
where CvsID='45B738C1-FFE8-4CFC-BE23-E191B23EA4AB' order by CrTime desc)
select Content=
'提醒商家 ('+IsNUll(RealName,'')+Convert(varchar(20),CrTime,100)+')'
from ##MyTempTable根据网上找的拼起来的。赋临时表的时候出错了,但是不知道该怎么写
where CvsID='45B738C1-FFE8-4CFC-BE23-E191B23EA4AB' order by CrTime desc)
select Content= '提醒商家 ('+IsNUll(RealName,'')+Convert(varchar(20),CrTime,100)+')'
from ##MyTempTable
from ConverseST_RemindLog a left outer join Member b on
a.MemberID=b.MemberID
where CvsID='45B738C1-FFE8-4CFC-BE23-E191B23EA4AB' order by CrTime desc
这样写就解决了我的需求~
into table临时表
from ConverseST_RemindLog a left outer join Member b on
a.MemberID=b.MemberID
where CvsID='45B738C1-FFE8-4CFC-BE23-E191B23EA4AB' order by CrTime desc
----这样不就建了一个临时表了么?
2、 select into