SQL Server Decimal type 
Author Message
 SQL Server Decimal type

Is there any data type in VB, other than variant, can be use to hold a
SQL Server DECIMAL(28,0) value?

Thanks in advance!



Tue, 20 Jan 2004 12:09:38 GMT  
 SQL Server Decimal type
Double should do the trick.. See the Chart at the link below

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vben...
ml/vagrpDataType.asp?frame=true

Scot

--------------------

Quote:

>Newsgroups: microsoft.public.vb.enterprise
>Subject: SQL Server Decimal type

>X-Newsreader: Forte Free Agent 1.21/32.243
>Lines: 4
>Date: Fri, 03 Aug 2001 04:09:38 GMT
>NNTP-Posting-Host: 24.100.181.125

>X-Trace: news3.rdc2.on.home.com 996811778 24.100.181.125 (Thu, 02 Aug 2001
21:09:38 PDT)
>NNTP-Posting-Date: Thu, 02 Aug 2001 21:09:38 PDT

>Path:

cppssbbsa01.microsoft.com!tkmsftngp01!newsfeed00.sul.t-online.de!t-online.de
!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newshub2.home.com!news.home
.com!news3.rdc2.on.home.com.POSTED!not-for-mail
Quote:
>Xref: cppssbbsa01.microsoft.com microsoft.public.vb.enterprise:61111
>X-Tomcat-NG: microsoft.public.vb.enterprise

>Is there any data type in VB, other than variant, can be use to hold a
>SQL Server DECIMAL(28,0) value?

>Thanks in advance!



Tue, 20 Jan 2004 23:46:42 GMT  
 SQL Server Decimal type
Checkout footnote 6 at this handy URL...

http://www.able-consulting.com/ADODataTypeEnum.htm

HTH

--
Patrick Logan, MCSD

Opinions expressed are my own and not necessarily those of my employer.



Wed, 28 Jan 2004 01:46:47 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Decimal data types in ADO/SQL

2. VB4, SQL-Server, decimal-comma

3. CR6 x SQL Server - datatype "decimal"

4. SQL Server Decimals??????

5. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

6. Passing Decimals to SQL Server Stored Procedures

7. newbie: decimal numbers in ADO/SQL SERVER

8. Passing Decimals to SQL Server Stored Procedures

9. Data Type Constants in SQL Server 6.5

10. VB.Net and SQl Server - adding values by type

11. Sql server Image data type

12. Retrieving SQL Server Text data type in VB.NET

 

 
Powered by phpBB® Forum Software