Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migrating isql command to sqlcmd in SQL 2005 Issue Expand / Collapse
Author
Message
Posted Tuesday, January 25, 2011 7:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 14, 2012 12:26 PM
Points: 1, Visits: 33
The following is the isql command which works
isql /S IMGTW011 /d ODR_DTEST /w600 /E /n h /s "|" /Q "exec upTransMinor91" /o d:\trans_Minor_91.out
The output for 2 fields in isql looks like
Interest Rate Unit_Prc/Div_Rt
0.071250 0.000000


The Output of the sqlcmd
SQLCMD /S IMGTW011 /d ODR_DTEST /w600 /E /n h /s "|" /Q "exec upTransMinor91" /o d:\trans_Minor_91.out
Interest Rate Unit_Prc/Div_Rt
7.1249999999999994E-2 0

The Precision of the above fields changed totally when i run it from isql & SQLCMD. I am running the same Stored Procedure in both places

The following is the Query which is in the Stored Procedure

Select "Interest Rate" = ISNULL(Interestt, 0.0),
"Unit_Prc/Div_Rt" = ISNULL (Per_Unit_Rt,0.0)
from Table

Not sure why this is happening. Any Help on this will be Greatly Appreciated
Post #1053147
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse