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.