34,838
社区成员




; with cte
as
(
select Address,Time,[Referrer URL]
from test2.dbo.['status 200$']
where charindex(['/home/',Referrer URL]>0 or charindex('/home/corner',Referrer URL)>0
)a
insert into mytable select * from cte
INSERT INTO mytable
select Address,Time,[Referrer URL] from test2.dbo.['status 200$']
where [Referrer URL]='/home/'or [Referrer URL]='/home/corner'
INSERT INTO mytable select Address,Time,[Referrer URL] from test2.dbo.['status 200$'] where [Referrer URL]='/home/'
or [Referrer URL] like '/home/c%'
INSERT INTO mytable
select Address,Time,[Referrer URL] from test2.dbo.['status 200$']
where [Referrer URL] ='/home/' or '/home/corner'