拼接查询
DECLARE @Tbl NVARCHAR(100) = 'Tbl_';
DECLARE @TableName NVARCHAR(MAX)
DECLARE @m_Where NVARCHAR(MAX)
DECLARE @SqlQuery NVARCHAR(MAX);
select @TableName=@TableName+QUOTENAME(CAST(LiaoPinLeiXingID AS VARCHAR(10))) from [Tbl_ZhuangJi]
--SET @SqlQuery = 'SELECT * FROM ' + @TableName +' where '+@m_Where;
print @TableName
-- 执行动态 SQL 查询
--EXEC sp_executesql @SqlQuery;