7,388
社区成员
发帖
与我相关
我的任务
分享SQLServer的存储过程难道不能输出超过255的字符长???
CREATE PROCEDURE PKG_TEST_TTT5
@tab1 varchar(4000) OUTPUT
AS
BEGIN
set @tab1 =
N'""" Unit tests for adodbapi""" """ adodbapi - A python DB API 2.0 interface to Microsoft ADO Copyright (C) 2002 Henrik Ekelund Email: <http://sourceforge.net/sendmessage.php?touser=618411> This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License,'
END
GO
请求输出一个长字符串(肯定是长过255)了,但是:
declare @v varchar(4000)
exec PKG_TEST_TTT5 @v output
select @v
发现只得到255个字， why?
不可思议!
@tab1 varchar(4000) OUTPUT
AS
BEGIN
set @tab1 =
N'""" Unit tests for adodbapi""" """ adodbapi - A python DB API 2.0 interface to Microsoft ADO Copyright (C) 2002 Henrik Ekelund Email: <http://sourceforge.net/sendmessage.php?touser=618411> This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License,'
END
GO
请求输出一个长字符串(肯定是长过255)了,但是:
declare @v varchar(4000)
exec PKG_TEST_TTT5 @v output
select @v
发现只得到255个字， why?
不可思议!
...全文
请发表友善的回复…
发表回复
yiyiyan762 2005-04-27
- 打赏
- 举报
修改一下你的查询分析器（工具-->选项-->结果）的每列最多字符数
mahongxi 2005-04-27
- 打赏
- 举报
但是用ADO客户端试确OK,不知为啥子?
mahongxi 2005-04-27
- 打赏
- 举报
昏~~~~~~~~~~~~~~~~~~~~~~
