Reading Time: 2 minutes This might be the worlds shortest blog post. If you’re looking to understand the SQL DECIMAL vs NUMERIC data types, understand this: The SQL Server DECIMAL and NUMERIC data types are synonyms and can be used interchangeably. I pulled that information directly from the Microsoft documentation: decimal and numeric (Transact-SQL). Continue Reading
SQL Server DECIMAL: Everything you need to know
Reading Time: 7 minutes The SQL Server DECIMAL data type is a very common data type you will see and use in your career as a database professional. It’s important for you to know how it works and the rules for setting it up. DECIMAL is, of course, ideal for when you need to Continue Reading
SQL Server ROLLBACK: Everything you need to know
Reading Time: 9 minutes In SQL Server, there are plenty of instances where you might want to undo a statement that was just ran. Maybe you wrote an UPDATE statement that modified too many rows, or maybe an INSERT statement wasn’t quite right. In these instances, it is great when the work is performed within a Continue Reading
Stored procedure with parameters: A guide for beginners
Reading Time: 11 minutes If you need to write a stored procedure within SQL Server, odds are it will be a stored procedure with parameters. It is much more common to see a stored procedure with parameters than one without parameters. It’s important you understand both input and output parameters, which we will discuss in this tutorial. I Continue Reading
SQL Server Unique Index: Everything you need to know
Reading Time: 8 minutes If you know a thing or two about Clustered indexes and Nonclustered indexes, you might be looking to “round out” the topic with an understanding of what a Unique index is. Unique indexes are a great way to enforce uniqueness in a column other than the Primary Key column. If Continue Reading