SQL十进制的ADO VBA类型？

I have some fields in a SQL table which are type decimal(x,y). In the VBA how do I represent these in the ADO parameters for a stored procedure argument? For example, a varchar would be declared using adVarChar:

我在SQL表中有一些类型为decimal(x,y)的字段。在VBA中,如何在存储过程参数的ADO参数中表示这些?例如,将使用adVarChar声明varchar:

Set prm = cmd.CreateParameter("@ColumnX", adVarChar, adParamInput, 50)

1 个解决方案

#1

Have a look at this page:

看看这个页面:

ADO Data Types

ADO数据类型

The two data types you may be interested in are adDecimal and adNumeric. The following post describes the difference between the two:

您可能感兴趣的两种数据类型是adDecimal和adNumeric。以下文章描述了两者之间的区别:

sqldatatypes - Is there any difference between DECIMAL and NUMERIC in SQL Server? - Stack Overflow

sqldatatypes - SQL Server中的DECIMAL和NUMERIC之间有什么区别吗? - 堆栈溢出

Here is an example: http://www.access-programmers.co.uk/forums/showthread.php?t=149631

这是一个例子:http://www.access-programmers.co.uk/forums/showthread.php?t = 149631

#1