EugeneChiang.com

Five Types of Accounts in Accounting

There are five main types of accounts in accounting, namely assets, liabilities, equity, revenue and expenses. Their role is to define how your company’s money is spent or received. Each category can be further broken down into several categories. Assets Account The assets account includes everything that your company owns. Assets are divided into tangible... » read more

Using ROW_NUMBER()

Numbers the output of a result set. More specifically, returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. ROW_NUMBER is a temporary value calculated when the query is run. There is no guarantee that the rows returned by a query using ROW_NUMBER() will... » read more

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