TSQL Business Days
Exclude weekends. Account for holidays.
TSQL Encrypt By Pass Phrase
Encrypt data with a passphrase using the TRIPLE DES algorithm with a 128 key bit length. Sources: https://docs.microsoft.com/en-us/sql/t-sql/functions/encryptbypassphrase-transact-sql?view=sql-server-2017
TSQL Date Format
Convert from MM/dd/yyyy to yyyy-MM-dd
Set IDENTITY_INSERT On and Off
Cannot insert explicit value for identity column in table ‘sometableWithIdentity’ when IDENTITY_INSERT is set to OFF
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
Using ROW_NUMBER()
Require OVER() clause to use ROW_NUMBER(). Have to use subquery to update row using ROW_NUMBER().
Copy Table Using TSQL
Copy table with all rows without creating the table first. Note: Does not copy over constraints.
Try Catch with Transaction
Try Catch in SQL with Transaction. Sources: https://docs.microsoft.com/en-us/sql/t-sql/functions/error-message-transact-sql?view=sql-server-2017