Visual Studio Version Number

The numbers correspond to the internal version numbers of various editions of Visual Studio http://en.wikipedia.org/wiki/Microsoft_Visual_Studio#History Visual Studio 6.0 (1998)Visual Studio .NET (2002) = version 7Visual Studio .NET 2003 = version 7.1Visual Studio 2005 = version 8Visual Studio 2008 = version 9Visual Studio 2010 = version 10Visual Studio 2012 = version 11Visual Studio 2013 = version... » read more

C# Format DateTime

Format Result .ToString(“MMMM dd, yyyy”) June 10, 2011 .ToString(“MM/dd/yyyy”) 05/09/2019 .ToString(“hh:mmtt”) 12:00AM .ToString(“hh:mm:ss tt”) 6:09:01 PM The “mm” custom format specifier The “mm” custom format specifier (plus any number of additional “m” specifiers) represents the minute as a number from 00 through 59. The minute represents whole minutes that have passed since the last hour.... » read more

SQL Server Type: money vs smallmoney

Data type Range Storage money -922,337,203,685,477.5808 to 922,337,203,685,477.5807 (-922,337,203,685,477.58to 922,337,203,685,477.58 for Informatica. Informatica only supports two decimals, not four.) 8 bytes smallmoney – 214,748.3648 to 214,748.3647 4 bytes The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent. For Informatica, the money and smallmoney data types are accurate to a one-hundredth of the monetary units... » read more

Power BI: Show Items With No Data

To enable the Show items with no data feature select a visual, then in the Fields well, right-click the field and select Show items with no data from the menu that appears, as shown in the following image: Sources: https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data

C# Format Decimal

Mask Format .ToString(“0.00”) X.XX .ToString(“C2”) $X,XXX.XX Source: https://docs.microsoft.com/en-us/dotnet/api/system.decimal.tostring?view=netframework-4.8

TransactionScope

Makes a code block transactional. Source: https://docs.microsoft.com/en-us/dotnet/api/system.transactions.transactionscope?view=netframework-4.8