--查询某表中各字段的最大长度
DECLARE my_cursor CURSOR SCROLL
FOR
SELECT name
FROM syscolumns
WHERE id = OBJECT_ID('tabDIYTable55');
OPEN my_cursor;
DECLARE @colname NVARCHAR(16);
DECLARE @value INT;
FETCH NEXT FROM my_cursor
INTO @colname;
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @value = MAX(LEN(@colname))
FROM JBL.dbo.tabDIYTable55;
PRINT @colname + ' 最大长度为: ';
PRINT @value 显示不一样
FETCH NEXT FROM my_cursor
INTO @colname;
END;
CLOSE my_cursor;
DEALLOCATE my_cursor;
--SELECT MAX(LEN(F720)) FROM JBL.dbo.tabDIYTable55;
如上用最下面的语句查询出来F20字段的最大长度是17,但print @Value 显示的是5?
什么原因?
谢谢!
加好友 
发短信
Post By：2021/7/29 11:28:00 [显示全部帖子]
