set @sql='Select ID,RecordsType,SiteName,SiteDoMain,SiteDoMain2,SiteDoMain3,SiteDoMain4,SiteDoMain5,SiteDoMain6,SiteDoMain7,SiteDoMain8,SiteDoMain9,SiteDoMain10,CompanyName,CompanyNameEN,SiteWorkAddress,ServerPhone,ServerEmail,RecordsChk,AddDateTime From SiteRecords Where SiteName=@SearchType Order By ID Desc'
什么是动态SQL?
这个算不算?
exec(@sql)
exec(@sql)
EXECUTE sp_executesql @SQL
exec(@sql)