In this tutorial, you will learn how to add new columns to table in SQL Server. Let's say we have a table called table_product and we want to add two columns named ProductCode and Description.
You might come with a scenario where you need to use if condition when there are two possible cases occur. For example, when you develop a program or website, you want to do some sort of scheduling that can synchronize your current records with the existing data.
In some occasion, you may want to delete a list of stored procedures with the same prefix name. You can do it easily using a while loop. You can use the following script and run in your SQL Query Panel