Learn how to fix the saving changes is not permitted in SQL Server.

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.

Learn how to use while loop in sql server.

Learn how to get the length of ntext column sql server.

Learn how to enable mixed mode authentication in sql server.

Learn how you can delete all tables in one go by using while loop in sql server.

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

Learn how you can view stored procedure content using Sql management studio or using sql query code.

Learn how to list all stored procedures in sql server.