Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Numeric Data Conversion from Oracle to SQL Server

Author  Topic 

rajbir
Starting Member

1 Post

Posted - 2009-08-10 : 16:20:18
Hi Forum

I am replicating from Oracle to SQL server with streams. There is a problem with Numeric colums.
Sql server require data with exact precision, but oracle has flexible precision. Is there any datatype available in SQL server for flexible precision.

The Cast function doesnt work in my case due to handling of some third party tools.

Please advice.

Thanks in advance,
Raj.

timmyms290
Starting Member

3 Posts

Posted - 2009-09-08 : 10:17:53
Do you need to use numerics? Can't you use bigint, tinyint, etc? They seem to be a lot more flexible.
Go to Top of Page

melina386
Starting Member

7 Posts

Posted - 2009-11-16 : 00:08:39
http://www.docs.hp.com/en/36216-90216/ch08s04.html
check with this link for cast function
----------------------------------------------
[url=http://www.e-datapro.net]Data entry india[/url]
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-11-16 : 04:47:05
Float and real are the only data types in sql server that supports flexible precision. Check out this link for the official documentation: http://msdn.microsoft.com/en-us/library/ms173773.aspx

- Lumbago
http://xkcd.com/327/
Go to Top of Page
   

- Advertisement -