No announcements
Found 3509668 threads
-
0 VotesSQL Server Money data type
The SQL data type "money" corresponds to "decimal" in .Net.Answered | 5 Replies | 18083 Views | Created by JohnDMP - Friday, September 12, 2008 8:49 PM | Last reply by GonzoKnight - Friday, May 14, 2010 7:41 PM
-
1 Votes
SQLGETDATA for money data type?
During conversion of DB-library API with SQL Server Native Client I find one more issue.Answered | 3 Replies | 7075 Views | Created by vatsa_mitr - Thursday, May 12, 2011 12:20 PM | Last reply by Ziran Lin - MSFT - Friday, May 13, 2011 5:32 PM -
1 Votes
Money Data Type confusion
"money" is a fun data type, isn't it.Answered | 4 Replies | 1394 Views | Created by Eshant Garg - Wednesday, July 31, 2013 3:44 PM | Last reply by Kalman Toth - Wednesday, July 31, 2013 8:46 PM -
0 Votes
use of money data type
you will find advantages of money over other datatypes Dorababu, I think you got is wrong MVP louis davidson explains why ***not** to use money......Answered | 3 Replies | 4229 Views | Created by Rajendra Kumbar - Tuesday, January 5, 2010 11:07 AM | Last reply by Chirag Shah - Tuesday, January 5, 2010 6:57 PM -
5 Votes
difference between Numeric and Money Data type in SQL Server
So, it the Money data type evil?Answered | 7 Replies | 35148 Views | Created by DonRamesh - Tuesday, February 14, 2012 10:28 PM | Last reply by SqlNightOwl - Tuesday, May 14, 2013 2:17 AM -
0 Votes
I have a column with data type float .how to give commas for this values.
If the data within the column is numeric then a numeric data type FLOAT is most appropriate.Answered | 3 Replies | 9205 Views | Created by vishveshk - Monday, June 21, 2010 1:38 PM | Last reply by David Dye - Monday, June 21, 2010 10:55 PM -
3 Votes
2008 R2 - Format all money types
Whenever data leaves SQL Server (into the client app) it is binary data.Answered | 18 Replies | 1072 Views | Created by Wild.Bill.Work - Thursday, August 13, 2015 1:01 PM | Last reply by Naomi N - Wednesday, August 19, 2015 2:55 PM -
1 Votes
Microsoft SQL Server 2008 R2 - Table - Column that data type is money, is rounding off when adding to a money data type column
Hi Everyone I have 2 columns that the data type is money, the i sum them on VIEW.Answered | 1 Replies | 749 Views | Created by Aron29 - Wednesday, September 11, 2013 2:06 PM | Last reply by Spooky201 - Wednesday, September 11, 2013 2:18 PM -
2 Votes
right data type quote?
Consider each of the following when you are choosing a data type: Try to choose the smallest data type that works for each ...Answered | 4 Replies | 1144 Views | Created by maca128 - Friday, January 29, 2016 11:02 AM | Last reply by Naomi N - Thursday, February 11, 2016 6:02 PM -
19 Votes
The size of a money column
Checking dump data from index page, money is stored as 8-byte value normally.Answered | 6 Replies | 1793 Views | Created by Igor Gelin - Monday, April 22, 2019 8:31 PM | Last reply by André Renato Furtado - Thursday, May 23, 2019 6:47 PM -
0 Votes
Saving money value in sql server
I have an application made in vb.net which is connected to a sql server database, In my database i have a column for inserting the prices for certain ...Answered | 2 Replies | 3052 Views | Created by Sid Williams - Monday, September 2, 2013 7:00 PM | Last reply by Sarat (SS) - Tuesday, September 3, 2013 2:46 AM -
1 Votes
Data types are not in the tables; phone, email, money
Are you using an external database?Answered | 4 Replies | 1979 Views | Created by Doc Natural - Wednesday, August 17, 2011 12:54 AM | Last reply by Frank Frazier - Wednesday, November 16, 2011 2:13 PM -
0 Votes
Check Money data type null in .Net
when reading the empty column, it will receive a System.DBnull object, we should make sure the data we got is not a DBNull object.Answered | 4 Replies | 5571 Views | Created by Pure Deal - Wednesday, August 4, 2010 1:52 PM | Last reply by NeverHopeless - Tuesday, August 10, 2010 9:03 PM -
3 Votes
Inserting currency symbols in money datatypes
This feature is just a convenience to prevent an error when data with a currency symbol is inserted.Answered | 2 Replies | 4590 Views | Created by IT researcher - Saturday, March 16, 2013 6:29 AM | Last reply by Rick Byham, Microsoft - Tuesday, March 19, 2013 4:15 PM -
2 Votes
What is the correct MSSQL Data type to use for Lightswitch Money format?
I have just experienced the same error you report, yet up until today had no problems with Money/Decimal or any other data type saving to SQL ...Answered | 15 Replies | 4607 Views | Created by Shadow_dog007 - Thursday, August 25, 2011 2:48 PM | Last reply by rmcsharry - Saturday, November 12, 2011 11:08 PM -
0 Votes
WPF sqldatareader and money type in ObservableCollection
"{Binding PartBBilling_Total, StringFormat=N2}" the money datatype is a decimal with 2dp so when imported into c# it gets ...Answered | 3 Replies | 1188 Views | Created by db_dweeb - Thursday, October 24, 2013 3:12 PM | Last reply by Andrew Brough - Thursday, October 24, 2013 4:33 PM -
1 Votes
Is it possible to bind the money type currency to another field in a row?
The Money type and controls do not support displaying a currency symbol that is retrieved from a different entity property.Answered | 2 Replies | 2833 Views | Created by Paul Keister - Friday, May 13, 2011 9:16 PM | Last reply by Justin Anderson - Saturday, May 14, 2011 12:14 AM -
1 Votes
Is there a way to Insert Data into a Lookup Column Type on a SharePoint List Destination in SSIS?
I'm loading data into a sharepoint list.Answered | 4 Replies | 9649 Views | Created by John Fitz Randolph - Friday, May 4, 2012 1:12 PM | Last reply by Philip M. Gaudet - Friday, July 25, 2014 11:21 PM -
0 Votes
Importing Stock quote data to Excel 2010 from MSN Money
Microsoft Certified Professional Microsoft MVP [Windows Server] Datacenter Management Disclaimer: This posting is provided ...Answered | 1 Replies | 1233 Views | Created by justphilip - Monday, October 17, 2016 3:22 PM | Last reply by Dave Patrick - Monday, October 17, 2016 6:14 PM -
0 Votes
Vs 2010 ADO.Net Entity Data Model does not offer 'Money' type
A conceptual model is translated to a storage model which may or may not support money type. like in your case sql server supports money type but ...Answered | 5 Replies | 5094 Views | Created by Paul Thibodeaux - Tuesday, August 31, 2010 1:50 AM | Last reply by Michael Sun [MSFT] - Monday, September 6, 2010 1:47 AM - Items 1 to 20 of 3509668 Next ›
No announcements
