Prev: Unique Constraints
Next: Execution plan for view
From: FrancescoG75 on 24 Mar 2010 11:34
I try to use SQLCMD in this way in a batch file:

sqlcmd -m 1 -S myserver -s " " -i "C:\MyFile.sql" -o "C:\ouptut.csv"

In a field of the output file I see this number 71.504.400.000.000.000
and this is incorrect.
The correct value that I see in Results of SQL Server is 71.504,40.
Infact if I save result from SQL SERVER in csv format the value is
correct.

How is possible?
How can I modify the batch file?

Thanks,
Francesco
From: sloan on 25 Mar 2010 19:41
Maybe you want to post the contents of MyFile.sql.....aka the query.



"FrancescoG75" <francescogherardo(a)gmail.com> wrote in message
news:2f250441-9231-47ca-9b7a-e6b00de13ae4(a)q21g2000yqm.googlegroups.com...
>I try to use SQLCMD in this way in a batch file:
>
> sqlcmd -m 1 -S myserver -s " " -i "C:\MyFile.sql" -o "C:\ouptut.csv"
>
> In a field of the output file I see this number 71.504.400.000.000.000
> and this is incorrect.
> The correct value that I see in Results of SQL Server is 71.504,40.
> Infact if I save result from SQL SERVER in csv format the value is
> correct.
>
> How is possible?
> How can I modify the batch file?
>
> Thanks,
> Francesco


 | 
Pages: 1
Prev: Unique Constraints
Next: Execution plan for view