Hi All,
Is there any possiblity to transfer Long data type value to SQL
Server?. I'm using DTS package to transfer data. I have to use only SQL
Server Tools or DTS package.
--
Thank you,
With Regards,
A.chellammal
Developer
by Chellamma » Tue, 13 Jan 2004 05:59:49
--
Thank you,
With Regards,
A.chellammal
Developer
by Aaron Bertrand [MVP » Tue, 13 Jan 2004 06:23:02
Can you use CONVERT? Also, if a long can be no more than 19 digits (I
think?), why would you want to store this in TEXT (which can store up to 2
GB of data)? Wouldn't it make more sense to store a numeric value using a
numeric data type, and if for some reason you want it to be character-based,
at least use a more reasonable VARCHAR?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
Quote:> Hi All,
> Is there any possiblity to transfer Long data type value to SQL
> Server?. I'm using DTS package to transfer data. I have to use only SQL
> Server Tools or DTS package.
> --
> Thank you,
> With Regards,
> A.chellammal
> Developer
1. Mapping SQL Server Data Types and ADO Data Type Enums
Does anyone have a document that maps ADO parameter data type enums to
their corresponding SQL Server data types?
3. Mapping ADO Data Types to SQL Server Data Types
4. Oracle on PC
5. Transfer Oracle Long Data value to SQL Server Long data value
6. FP DOS slow to print to network
7. sql data type vs vb data type
8. Testing Performance of Queries
9. conversion of ODBC SQL data types to ODBC C data types
10. Data Type SQL Server7.0 need a non decimal 1 E 19 data type
11. SQL timestamp data type - correspondency with c++ data type
12. mssql data types vs JAVA data types
13. Converting OLEDB data types to VC++ data types