以下是联机sql Server帮助的一段示例代码,理解不了,请帮忙!!
USE pubs
GO
DECLARE @tablename sysname
SET @tablename = N'authors'
table_loop:
IF (@@FETCH_STATUS <> -2)
BEGIN
SELECT @tablename = RTRIM(UPPER(@tablename))
EXEC ("SELECT """ + @tablename + """ = COUNT(*) FROM "
+ @tablename )
PRINT " "
END
FETCH NEXT FROM tnames_cursor INTO @tablename
IF (@@FETCH_STATUS <> -1) GOTO table_loop
GO
第4行:N'authors'是什么意思?
第9行:EXEC ("SELECT """ + @tablename + """ = COUNT(*) FROM "
+ @tablename )
select之后为什么要有3行引号?
还有就是这组语言究竟是什么意思?
谢谢