Reading Time: 10 minutes A proper understanding of Views in SQL Server will definitely help you become a better database developer. Views allow us to basically save a query as an object in the database, and make it very easy to run the query with simple commands. But what if we want to make Continue Reading
Cannot update an IDENTITY column? Here’s why
Reading Time: 7 minutes The IDENTITY property is an extremely useful tool we can use in SQL Server to automate the values in a column. It can be especially useful for primary key columns. This property will automatically add a new integer value to a column when a new row is inserted into the 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
UPDATE statement with JOIN: How it’s done
Reading Time: 8 minutes One of the more tricky things I learned early in my career was how to do an UPDATE statement with a JOIN. This is a very interesting task to think about. There may be situations when we want to perform an UPDATE to the results of a JOIN query, such Continue Reading