--varchar可以存8k字符;nvarchar可以存4k字符(UNICODE)
DECLARE @chvSqlCmd varchar(8000)
SET @chvSqlCmd=''
SELECT @chvSqlCmd=@chvSqlCmd+'SELECT '''+NAME+''',COUNT(*) FROM '+NAME+CHAR(13)+'UNION'+CHAR(13)
FROM DBO.SYSOBJECTS WHERE XTYPE='U' AND NAME!='dtproperties'
SET @chvSqlCmd=SubString(@chvSqlCmd,1,len(@chvSqlCmd)-7)
--The 7 is len('UNION'+char(13),+char(13))
EXEC (@chvSqlCmd)
DECLARE @chvSqlCmd varchar(8000)
SET @chvSqlCmd=''
SELECT @chvSqlCmd=@chvSqlCmd+'SELECT '''+NAME+''',COUNT(*) FROM '+NAME+CHAR(13)+'UNION'+CHAR(13)
FROM DBO.SYSOBJECTS WHERE XTYPE='U' AND NAME!='dtproperties'
SET @chvSqlCmd=SubString(@chvSqlCmd,1,len(@chvSqlCmd)-7)
--The 7 is len('UNION'+char(13),+char(13))
EXEC (@chvSqlCmd)