="select TestSurveyID,'http://www.findoout.cn/survey/viewsurvey.aspx?tid='+CONVERT(varchar(10),testsurveyid) as url,Title from TestSurvey with (nolock) where Title like '%"&B2&"%'"
B2为单元格,与通过&号与字符链接起来
Powered by: 博客园 Copyright © 2024 高山老王 Powered by .NET 8.0 on Kubernetes