What is the data type for Currency in SQL Server?

answering to the question in the title, the datatype for currency is MONEY.

the money datatype will store the information only, without the format: in your example the information is 11.23 so that’s what is saved into the database.

the $ sign is part of the format so it will not be stored into the money field.

the usual solution is to have a MONEY field for the amount and a VARCHAR field for the currency symbol/name.

Related Posts:

  1. How to drop a table if it exists?
  2. SQL Server Installation – What is the Installation Media Folder?
  3. SQL-Server: The backup set holds a backup of a database other than the existing
  4. Search all tables, all columns for a specific value SQL Server [duplicate]
  5. vs shell installation has failed with exit code 1638
  6. XOR in SQL Server
  7. An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
  8. LIKE vs CONTAINS on SQL Server
  9. Case in Select Statement
  10. What is a stored procedure?
  11. Inserting multiple rows in a single SQL query? [duplicate]
  12. SQL Server: Difference between PARTITION BY and GROUP BY
  13. Self Join to get employee manager name
  14. Conversion failed when converting date and/or time from character string while inserting datetime
  15. error, string or binary data would be truncated when trying to insert
  16. How can I do an UPDATE statement with JOIN in SQL Server?
  17. Must declare the scalar variable
  18. Rename column SQL Server 2008
  19. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  20. The SQL OVER() clause – when and why is it useful?
  21. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  22. Function to Calculate Median in SQL Server
  23. SQL Server IF EXISTS THEN 1 ELSE 2
  24. SQL Server Management Studio, how to get execution time down to milliseconds
  25. Drop a temporary table if it exists
  26. How do I escape a single quote in SQL Server?
  27. How Stuff and ‘For Xml Path’ work in SQL Server?
  28. IDENTITY_INSERT is set to OFF – How to turn it ON?
  29. An attempt was made to access a socket in a way forbidden by its access permissions
  30. Each GROUP BY expression must contain at least one column that is not an outer reference
  31. Cannot Connect to Server – A network-related or instance-specific error
  32. Import / Export database with SQL Server Server Management Studio
  33. Best way to do nested case statement logic in SQL Server
  34. How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
  35. The multi-part identifier could not be bound
  36. Get day of week in SQL Server 2005/2008
  37. How to join two tables by multiple columns in SQL?
  38. incorrect syntax error CREATE VIEW must be the only statement in the batch
  39. Attach (open) mdf file database with SQL Server Management Studio
  40. Sql Server string to date conversion
  41. Why use a READ UNCOMMITTED isolation level?
  42. Find all tables containing column with specified name – MS SQL Server
  43. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  44. How can I import an Excel file into SQL Server?
  45. How to group by month from Date field using sql
  46. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  47. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  48. Is there a combination of “LIKE” and “IN” in SQL?
  49. Search text in stored procedure in SQL Server
  50. How to convert SQL Server’s timestamp column to datetime format
  51. SQL Server IF NOT EXISTS Usage?
  52. Arithmetic overflow error converting expression to data type datetime. (while displaying date time..)
  53. How to join two tables by multiple columns in SQL?
  54. How do you create a yes/no boolean field in SQL server?
  55. Escape Character in SQL Server
  56. MS SQL compare dates?
  57. I want to use CASE statement to update some records in sql server 2005
  58. What represents a double in sql server?
  59. How do I fix ‘Invalid character value for cast specification’ on a date column in flat file?
  60. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  61. SELECT DISTINCT on one column
  62. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it
  63. TSQL PIVOT MULTIPLE COLUMNS
  64. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  65. Why do table names in SQL Server start with “dbo”?
  66. Round *UP* to the nearest 100 in SQL Server
  67. Equivalent of Oracle’s RowID in SQL Server
  68. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  69. Regex pattern inside SQL Replace function?
  70. sql query to return differences between two tables
  71. Subtract one day from datetime
  72. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  73. Is it possible to specify condition in Count()?
  74. Replacing NULL with 0 in a SQL server query
  75. SQL Server: Make all UPPER case to Proper Case/Title Case
  76. How do I query for all dates greater than a certain date in SQL Server?
  77. Backup a single table with its data from a database in sql server 2008
  78. Error converting data type varchar
  79. How to execute a stored procedure within C# program
  80. Conditional JOIN Statement SQL Server
  81. Temporary table in SQL server causing ‘ There is already an object named’ error
  82. I want to use CASE statement to update some records in sql server 2005
  83. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  84. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  85. Call a stored procedure with parameter in c#
  86. What datatype should be used for storing phone numbers in SQL Server 2005?
  87. What are database constraints?
  88. How to select the last record of a table in SQL?
  89. SQL WHERE.. IN clause multiple columns
  90. SHOWPLAN permission denied in database ‘tempdb’. in sql server 2008
  91. Append table to an existing one: SQL Server
  92. SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
  93. “select * into table” Will it work for inserting data into existing table
  94. Filter data based on date in sql
  95. Update query using Subquery in Sql Server
  96. How to truncate string using SQL server
  97. Using Excel VBA to run SQL query
  98. “The transaction log for database is full due to ‘LOG_BACKUP'” in a shared host
  99. Pad a string with leading zeros so it’s 3 characters long in SQL Server 2008
  100. How to connect to database from Unity

Leave a Comment