Copy Table Using TSQL
Copy table with all rows without creating the table first. Note: Does not copy over constraints.
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 Format Result DateTime.Now.ToString(“MM/dd/yyyy”) 05/29/2015 DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 05:50 DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 05:50 AM DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015... » 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
Power BI: Disable Filter Panel
Disable Filter Panel from displaying on the reports. File -> Options & Settings In report edit, you will now see this panel…