Many of you may wonder why the parameter that you try to pass doesnt work when you try to use Select Top Statement.

How to use sql query to show all tables in sql server.

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.

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