看不出为什么不对 insert into #NewThread select Tb.Topic_ID,Tb.Author_ID,Tb.Message,Tb.Message_date from tblThread as Tb inner join tblAuthor as AU ON AU.Author_ID = Tb.Author_ID where Tb.Message_date >= @datBefore and Tb.Message_date < @datToday and AU.Group_ID = 12 order by Message_date' select * from #NewThread 这样呢?不过好象没有什么区别
看不出有什么不对的地方 insert into #NewThread select Tb.Topic_ID,Tb.Author_ID,Tb.Message,Tb.Message_date from tblThread as Tb inner join tblAuthor as AU ON AU.Author_ID = Tb.Author_ID where Tb.Message_date >= @datBefore and Tb.Message_date < @datToday and AU.Group_ID = 12 order by Message_date' select * from #NewThread 这样呢?不过好象没有区别
insert into #NewThread select Tb.Topic_ID,Tb.Author_ID,Tb.Message,Tb.Message_date
from tblThread as Tb
inner join tblAuthor as AU
ON AU.Author_ID = Tb.Author_ID
where Tb.Message_date >= @datBefore and Tb.Message_date < @datToday and AU.Group_ID = 12
order by Message_date'
select * from #NewThread
这样呢?不过好象没有什么区别
insert into #NewThread select Tb.Topic_ID,Tb.Author_ID,Tb.Message,Tb.Message_date
from tblThread as Tb
inner join tblAuthor as AU
ON AU.Author_ID = Tb.Author_ID
where Tb.Message_date >= @datBefore and Tb.Message_date < @datToday and AU.Group_ID = 12
order by Message_date'
select * from #NewThread
这样呢?不过好象没有区别