好的呀:
declare @TableName varchar(20)
set @TableName='TLoginHistory_00_01 '
DECLARE @SQL NVARCHAR(4000)
SET @SQL = N'SELECT @Cnt2=COUNT(*) FROM '+ @TableName +
N' WHERE @Dt BETWEEN CONVERT(VARCHAR(13),LoginTime,20) AND CONVERT(VARCHAR(13),GETDATE(),20)'
print @sql--结果
/*
SELECT @Cnt2=COUNT(*) FROM TLoginHistory_00_01 WHERE @Dt BETWEEN CONVERT(VARCHAR(13),LoginTime,20) AND CONVERT(VARCHAR(13),GETDATE(),20)*/
declare @TableName varchar(20)
set @TableName='TLoginHistory_00_01 '
DECLARE @SQL NVARCHAR(4000)
SET @SQL = N'SELECT @Cnt2=COUNT(*) FROM '+ @TableName +
N' WHERE @Dt BETWEEN CONVERT(VARCHAR(13),LoginTime,20) AND CONVERT(VARCHAR(13),GETDATE(),20)'
print @sql--结果
/*
SELECT @Cnt2=COUNT(*) FROM TLoginHistory_00_01 WHERE @Dt BETWEEN CONVERT(VARCHAR(13),LoginTime,20) AND CONVERT(VARCHAR(13),GETDATE(),20)*/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货