SELECT count([tel])
,[smscontent]
FROM [Address].[dbo].[T_addr]
where smscontent like '%地址:深圳市宝安区44区顺丰路物业大楼东座5楼%'
,[smscontent]
FROM [Address].[dbo].[T_addr]
where smscontent like '%地址:深圳市宝安区44区顺丰路物业大楼东座5楼%'
group by [smscontent]
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [src]
,[tel]
,[smscontent]
FROM [Address].[dbo].[dizhi_source]
where smscontent like '%地址:深圳市宝安区44区顺丰路物业大楼东座5楼%'