Reading Time: 7 minutes The DATENAME function is a system function in Microsoft SQL Server we can use to present meaningful date information to the user. We use this function to basically spell out a specific part of a date value. For example, if we have a date of 4/1/2021, we can use DATENAME to Continue Reading
DATETIME2 Data Type: Explained
Reading Time: 7 minutes The DATETIME2 data type is one of several data types used to keep track of date and time information, obviously. Just like any other data type, there is a time and place where DATETIME2 might be the preferred type to use over other date and time types, like it’s close Continue Reading
SQL Integer Data Types – Everything you need to know
Reading Time: 6 minutes Knowing the difference between all the integer data types available to us in Microsoft SQL Server is very important when it comes to the task of designing and developing SQL Server databases. Most people don’t realize that a data type is essentially a constraint, meaning the data type you choose Continue Reading
Are you making this ROLLBACK mistake in your stored procedures?
Reading Time: 9 minutes If you read my post about the 6 rules you should know about SQL Server transactions, you should know there is one rule that can be a bit tricky. This rule centers around the idea of doing a ROLLBACK within a stored procedure. The rule is this: When you leave Continue Reading