Default value format of a stored procedure parameter(of datatype : money)

0 votes

1 answer

611 views

sql-server sql-server-2016 format money locales

                          With my query:  

    SELECT (CAST(0.00 AS MONEY))

I am expecting a result : 0.00

But it shows me the result: 0,00(with comma)

I checked this query ,when i found that,the CREATE PROCEDURE script displays the default value as 
[money] = 0,0000, for one of the input parameters of a procedure.

How can i make the CREATE PROCEDURE display it with '.' instead of ','?

Asked by minijebu (11 rep)

Sep 6, 2019, 09:07 AM
Last activity: Mar 2, 2020, 01:01 PM

Default value format of a stored procedure parameter(of datatype : money)

Related Questions