34,591
社区成员
发帖
与我相关
我的任务
分享
DECLARE @tables CHAR(11);
DECLARE @tablename CHAR(11);
DECLARE @BeginDate DATETIME;
DECLARE @tabletime CHAR(6);
SET @tables = 'pay_j';
SET @BeginDate = '2017-11-1';
SET @tabletime = LEFT((CONVERT(VARCHAR(10), @BeginDate, 112)), 6);
SET @tablename = RTRIM(LTRIM(@tables)) + RTRIM(LTRIM(@tabletime));
PRINT @tablename;
DECLARE @sql NVARCHAR(max)='SELECT * FROM '+@tablename;
EXEC(@sql)