Tag: SQL

To delete duplicate records using MSSQL you can use the following snippet. The table must have identity column, which will be used to identify the duplicate records.

To check if a Table exists in SQLite you can use the following snippet.

To give a user admin rights in MySql you can use the following snippet. Sample mySql Query

In MSSQL IF ELSE is not supported inside the SQL-Query. For a similiar behaviour you should use CASE WHEN keyword. Sample Query

To change user password in WordPress using MySql you can use the following query. Sample MySql

Every default WordPress installation will create an account with a default Admin username. This can be a security issue. To change default Admin Username in WordPress you can use the…

To check if a column exists in MSSQL you can use the following snippet. Sample MSSQL

To select date from datetime in MSSQL you can use the following snippet. Sample MSSQL The 104 is for tt.mm.jjjj, a list of formats can be found at the MSDN…

To learn how to use the Space() function in MSSQL you can take a look at the following snippet.   Let’s say you have a table (tblTest) like this: ID…

To list all user defined functions in MSSQL you can use the following snippet. Sample MSSQL