TSQL Date Format
Letter Note yyyy 4 Digit Year MM 2 Digit Month dd 2 Digit Day HH 2 Digit Hour (24 hour format) mm 2 Digit Minute Sources: https://www.mssqltips.com/sqlservertip/2655/format-sql-server-dates-with-format-function/
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Set IDENTITY_INSERT On and Off
Cannot insert explicit value for identity column in table ‘sometableWithIdentity’ when IDENTITY_INSERT is set to OFF
C# Partial Class
It is possible to split the definition of a class, a struct, an interface or a method over two or more source files. Each source file contains a section of the type or method definition, and all parts are combined when the application is compiled. Partial Classes There are several situations when splitting a class definition is desirable:... » read more
Sql Grant Permission
Grants permissions on a table, view, table-valued function, stored procedure, extended stored procedure, scalar function, aggregate function, service queue, or synonym. Syntax Object permission Implied by object permission Implied by schema permission ALTER CONTROL ALTER CONTROL CONTROL CONTROL DELETE CONTROL DELETE EXECUTE CONTROL EXECUTE INSERT CONTROL INSERT RECEIVE CONTROL CONTROL REFERENCES CONTROL REFERENCES SELECT RECEIVE... » read more
C# Import CSV File
Remember to add reference to Microsoft.VisualBasic
Accounting: Credit vs Debt
When cash is received, debit Cash. When cash is paid out, credit Cash. When revenues are earned, credit a revenue account. When expenses are incurred, debit an expense account.
Web Application Project is configured to use IIS. You do not have permission to access the IIS configuration file.
Error: When trying to load web projects in Visual Studio, you get the following error… Soution: Browse to C:\Windows\System32\inetsrv and then double-click the “config” directory. Do the same for the C:\Windows\System32\inetsrv\config\export directory and also the other directories in C:\Windows\System32\inetsrv. Now you will be able to open the Visual Studio Web Application Project without a problem.... » read more
Ledger Account Number
Ledger account numbering example. 1000 ASSETS 2000 LIABILITIES 3000 OWNERS EQUITIES 4000 REVENUE 5000 COST OF GOODS SOLD 6000 – 7000 OPERATING EXPENSES Simple Example Chart of Accounts Asset Accounts 101 Bank/Cash at Bank[ 102 Cash 108 Deferred Expense 110 Other A52312 112 Accounts Receivable 116 Supplies 130 Prepaid Insurance 157 Equipment 158 Accumulated Depreciation Equipment... » read more
Credit Card Ledger Account
Liabilities include any type of debt that you owe in the form of credit cards, lines ofcredit, student loans, mortgages, and overdraft protection. … Credit cards do not increase your net worth because credit cards are not assets, they are liabilities.
General Ledger
A general ledger (GL) is a set of numbered accounts a business uses to keep track of its financial transactions and to prepare financial reports. Each account is a unique record summarizing each type of asset, liability, equity, revenue and expense. General Ledger Accounts The accounts that are used to sort and store transactions are found in the company’s general ledger.... » read more