存储过程参数(文本) [英] Stored Procedure Parameters (text)
问题描述
我有一个存储过程,它带参数@description,数据类型为
设置为文本。
在我的ASP中我有以下内容:
..Parameters.Append
..CreateParameter(" @ description",adVarChar,adParam Input,255,varDesc))
我已经看到其他SP的例子,adVarChar设置为1000及以上!这是
的应该做的方式还是有匹配的参数类型我应该用
使用?
任何帮助赞赏。
菜刀
I have a stored procedure that takes parameter @description with datatype
set to text.
In my ASP I have the following:
..Parameters.Append
..CreateParameter("@description",adVarChar,adParam Input,255,varDesc))
I''ve seen other examples of SPs with adVarChar set to 1000 and up! Is this
the way it should be done or is there a matching parameter type I should be
using?
Any help appreciated.
chopper
推荐答案
Chopper写道:
Chopper wrote:
我有一个将参数@description与
数据类型设置为文本的存储过程。
在我的ASP中,我有以下内容:
.Parameters.Append
.CreateParameter(" @ description", adVarChar,adParamI nput,255,varDesc))
我已经看到了将adVarChar设置为1000及以上的SP的其他示例!
这是应该做的方式还是有匹配的参数类型
我应该使用?
I have a stored procedure that takes parameter @description with
datatype set to text.
In my ASP I have the following:
.Parameters.Append
.CreateParameter("@description",adVarChar,adParamI nput,255,varDesc))
I''ve seen other examples of SPs with adVarChar set to 1000 and up! Is
this the way it should be done or is there a matching parameter type
I should be using?
我写了一个存储过程代码生成器这是
可从
http://www.thrasherwebdesign.com/ind...asp&c=&a=clear
>
您可以在
http查找数据类型映射://www.able-consulting.com/ADODataTypeEnum.htm 如果您希望继续手工编码这些东西,请使用
HTH,>
Bob Barrows。
I''ve written a Stored Procedure Code Generator which is
available for download at
http://www.thrasherwebdesign.com/ind...asp&c=&a=clear
You can look up the datatype mappings at
http://www.able-consulting.com/ADODataTypeEnum.htm if you wish to continue
coding these things by hand.
HTH,
Bob Barrows.
在您的数据库中(我假设是Access),您可以设置文本
字段的长度。这是值得使用的。
Chopper < CH ***** @ despammed.com>在消息中写道
news:3f ********************* @ news.dial.pipex.com ..。
In your database (I assume Access) you would have set the length of the text
field. That''s the value to use.
"Chopper" <ch*****@despammed.com> wrote in message
news:3f*********************@news.dial.pipex.com.. .
我有一个存储过程,它将参数@description与数据类型
设置为文本。
在我的ASP中我有以下内容:
.Parameters.Append
.CreateParameter (@ description,adVarChar,adParamI nput,255,varDesc))
我已经看到了将adVarChar设置为1000及以上的SP的其他示例!这是
它应该做的方式还是有一个匹配的参数类型我应该
使用?
任何帮助赞赏。
chopper
I have a stored procedure that takes parameter @description with datatype
set to text.
In my ASP I have the following:
.Parameters.Append
.CreateParameter("@description",adVarChar,adParamI nput,255,varDesc))
I''ve seen other examples of SPs with adVarChar set to 1000 and up! Is this
the way it should be done or is there a matching parameter type I should be using?
Any help appreciated.
chopper
" Tom B" < SH ***** @ hotmail.com>在消息中写道
news:eK ************* @ TK2MSFTNGP12.phx.gbl ...
"Tom B" <sh*****@hotmail.com> wrote in message
news:eK*************@TK2MSFTNGP12.phx.gbl...
在你的数据库中(我假设Access)您可以设置
文本字段的长度。这是值得使用的。
In your database (I assume Access) you would have set the length of the text field. That''s the value to use.
< snip>
感谢您的回复。
它是SQL Server 2000.数据库中的字段是''Text''类型,
长度为16.
我找不到匹配的在使用ASP传递参数时输入,这是我想要弄清楚的。
<snip>
Thanks for your reply.
It''s SQL Server 2000. The field in the database is of type ''Text'' with
length 16.
I cannot find a matching type when passing the parameter using ASP which is
what I''m trying to figure out.
这篇关于存储过程参数(文本)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!