DECLARE @TableName NVARCHAR(128)
DECLARE @SQL NVARCHAR(MAX)

-- 获取表名
SELECT @TableName = 'YourTablePrefix_' + SomeColumn 
FROM SomeTable 
WHERE SomeCondition = 'SomeValue'

-- 构建动态SQL
SET @SQL = N'SELECT * FROM ' + QUOTENAME(@TableName) + ' WHERE SomeOtherCondition = @Param'

-- 执行动态SQL
EXEC sp_executesql @SQL, N'@Param INT', @Param = 123


DECLARE @Tbl NVARCHAR(100) = 'Tbl_';
DECLARE @TableName NVARCHAR(MAX) 
DECLARE @m_Where NVARCHAR(MAX) 
DECLARE @SqlQuery NVARCHAR(MAX);

select @TableName=@Tbl+CAST(LiaoPinLeiXingID AS VARCHAR(10)) ,@m_Where='ID='+CAST(LiaoPinID AS VARCHAR(10)) from [Tbl_ZhuangJi]

SET @SqlQuery = 'SELECT * FROM ' + @TableName +' where '+@m_Where;

print @SqlQuery
-- 执行动态 SQL 查询
--EXEC sp_executesql @SqlQuery;