29 Sep, 2019
If you want to find a list of tables column contains specific name in SQL server, you can easily using the following query.
12 Feb, 2018
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.
05 Feb, 2018
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.
23 Jan, 2018
Sometimes when working a team, you want to see if there are some changes have been made in the stored procedures. Whether they have been created new or have been altered recently. If you want to know if there are some changes have already been made, you can use the following simple queries.
25 Sep, 2017
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.
12 May, 2016
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.
14 Apr, 2016
Before running an SQL script to create a table dynamically, it would be a good step if you perform a checking if a table already exists. If it does, you may want to skip creating the table otherwise you will get an error exception.
03 Sep, 2014
Learn how to convert sql date into the first of day of the given date. The following example of sql code will help you to convert the a date given and return the 1st day of the given date.
08 Aug, 2014
Learn how to replace break line in TSQL
02 Aug, 2014
Learn how you can check if a function is already exists in sql server.