好象你的动态SQL连接有问题:
不明白''' + @KeyWord +''' 等要用单引号!! '+@keyword+' 不就可以了吗?
try:
Set @strSql=@strSql + 'Select F_ID,F_Title,F_SubTitle,F_Content,F_Department,F_Author,F_Module,F_Time,'+ @KeyWord +' as F_KeyWord,' + @TableName + 'as F_WhichTable from ' +@TableName + ' Where Contains(F_Title,' +@KeyWord +') or Contains(F_SubTitle,' +@KeyWord+')’
不明白''' + @KeyWord +''' 等要用单引号!! '+@keyword+' 不就可以了吗?
try:
Set @strSql=@strSql + 'Select F_ID,F_Title,F_SubTitle,F_Content,F_Department,F_Author,F_Module,F_Time,'+ @KeyWord +' as F_KeyWord,' + @TableName + 'as F_WhichTable from ' +@TableName + ' Where Contains(F_Title,' +@KeyWord +') or Contains(F_SubTitle,' +@KeyWord+')’
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货