How to check if a column exists in a Sql Server table?

How to check if a column exists in a Sql Server table?

If you have a situation where you want to add a column into a table in SQL Server, it would be a good idea to perform a check first if a column has already existed in a table. Otherwise, if you try to add a duplicate column, you may get an error message when you try to add a column via SQL query.

How to order the SQL query result by best match keyword search?

How to order the SQL query result by best match keyword search?

If you develop a website or a program that allows your users to perform a search. When the users perform a search query, you probably want to return the best match result first because it is actually more relevant to the search they need. For example, let says we have a database table contains the following list of product.
How to check if a function exists in Sql Server?

How to check if a function exists in Sql Server?

When creating a function dynamically, it is a best practice to perform a check if a particular function you want to create has already existed in a database. To perform a check of an existing function you can use the following EXISTS keyword. If the function does not exist then perform a creation of the function.
How to sort comments with nested replies in SQL Server?

How to sort comments with nested replies in SQL Server?

Do you need to sort comments with nested replies in SQL Server? Well this can be easily done by combining the same table using the UNION ALL join to populate the comments content. There is a trick to used to sort the comments which use the combination of a record ID field with the row number index.