EugeneChiang.com

SQL Server Compatibility Level

Sets Transact-SQL and query processing behaviors to be compatible with the specified version of the SQL Server Database Engine.  Product Database Engine Version Default Compatibility Level Designation Supported Compatibility Level Values SQL Server 2019 preview 15 150 150, 140, 130, 120, 110, 100 SQL Server 2017 (14.x) 14 140 140, 130, 120, 110, 100 Azure... » read more

Check Actively Running Jobs Script

Disable All Jobs Script

Generate a script to disable all active jobs on server. Returns all jobs that are not idle or suspended.

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# Patch String

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