Hi guys,

Does anyone know how to extract the currency symbol and measurement
unitsusing an ISQL query?


For instance, in .NET I can very easily do the following
-Thread.CurrentThread.CurrentCulture.NumberFormat.CurrencySymbol and
System.Globalization.RegionInfo.CurrentRegion.IsMetric

Is such a thing possible under SQL Server?

Cheers

MB

mukesh bhakta (mukesh_bha***@hotmail.com) writes:
I don't think it even makes sense. Measurement unit certanly doesn't,
because SQL Server does not use any measurement unit as far as I recall.

Currency symbols are used with the money data type, but I don't really
know whether this affected by language settings. (Which are separate from
Windows regional settings.) A quick test indicated that all of $, £
and ¤ were understood as currency signs.

I have found the only way is to access the Windows registry using the
sp's supplied inside SQL Server.

mukesh bhakta (mukesh_bha***@hotmail.com) writes:
But I can't really see that you have any use for this information?

convert INT
A difficult Combining Rows problem
How to use OPENXML to retrieve detail lineitems
what is general/conventional way to reduce/prevent deadlock?
Complicated OR