Reading Time: 6 minutes Stored procedures are a major part of any SQL Server database. They are the tools we use to introduce programming logic into our databases, and allow us to repeatedly run complex code. If you are new to SQL Server, you should definitely focus much of your learning towards understanding how Continue Reading
Stored Procedures
How to change a table name in SQL Server
Reading Time: 6 minutes Changing a table name in Microsoft SQL Server is a very easy task. Microsoft has a great built-in stored procedure we can use to easily change a table name. The stored procedure is called SP_RENAME. In this very brief tutorial, we’ll discuss how to use the SP_RENAME stored procedure and Continue Reading
How to change a column name in SQL Server: Explained for Beginners
Reading Time: 6 minutes So you need to change a column name in your database. Maybe you messed up the name from the start, or your team decided the name needs to change for business reasons. Either way, it’s got to change. Luckily, the process to change a column name is not too difficult 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
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
The ONE skill you should have if you want to be a Database Developer
Reading Time: 9 minutes If you want to get into the fields of database development, database administration or data science, there is one skill you should have that will give you an advantage and make it easier to learn the tools necessary to do your job. This is a skill most database professionals already Continue Reading
SQL Server Cursors: A How-To Guide
Reading Time: 9 minutes You will likely find yourself needing to use the capabilities of a cursor to accomplish some task in Microsoft SQL Server at some point in your career as a database professional. Cursors are the tool we use when working with large amounts of data, where you need to basically iterate Continue Reading
SQL Server WHILE loop: A decision structure you should know
Reading Time: 7 minutes The WHILE loop is one of the most basic tools you should know when you are first starting out with Microsoft SQL Server. Sometimes when working with SQL Server, you need certain code to execute several times in a loop while some condition is true. As soon as that condition Continue Reading
SQL Server Stored Procedures: The Ultimate Guide for Beginners
Reading Time: 12 minutes If you are planning on spending any time at all working with SQL Server, you should probably expect to encounter stored procedures very early in your career. Stored procedures are very common objects found in SQL Server databases. They are basically what we use to write programming logic within SQL Continue Reading
IDENTITY Column in SQL Server: Everything you need to know
Reading Time: 14 minutes The IDENTITY property is a very common property to see in SQL Server tables. It’s important to understand what it is, and how it can help you maintain data in your tables. In this tutorial, we will discuss everything you need to know about the IDENTITY property, including: 1. What Continue Reading