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/
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