sql server中exec sp_executesql 的使用问题？-灵析社区

DECLARE @doctype VARCHAR(64); SELECT @doctype = oid FROM pdmdoctype WHERE name = 'BOM表'; DECLARE @sql NVARCHAR(1000); SET @sql = '... where createtime >= ''' + @BeginTime + ''' and createtime <= ''' + @EndTime + ''' and version=1 ...';