How to use a REGEX in an SQL SELECT query
The article explains how to use a regular expression in an SQL select query to find images that end with #x# in a WordPress database.
SQL Server
How to generate SQL create table script using phpMyAdmin
Learn how to generate an SQL "create table" script using phpMyAdmin for recreating tables in different environments or for automation purposes.
SQL Management Studio – How to generate change scripts
Title: "How to Generate Change Scripts in SQL Management Studio
SQL – SELECT query where case insensitive and wildcard
The article provides two methods to perform a case-insensitive search on an SQL table using the \* wildcard and the % wildcard while being collate case-sensitive.
SQL Management Studio – How to change varchar(n) to varchar(MAX)
This article provides instructions on how to modify a column's data type from varchar(x) to varchar(MAX) using SQL Management Studio.This article explains how to change a column's data type from…
SQL Management Studio – ‘Saving changes is not permitted’ message when changing table
How to resolve "Saving changes is not permitted" error in SQL Management Studio while trying to change a table's structure.How to resolve "Saving changes is not permitted" error in SQL…
SQL Server – How to set a datetime field to automatically use current date/time
This article explains how to set a 'datetime' field in an SQL Server database to automatically display the current date and time when the record is created.How to set a…
How to install SQL Management Studio 2008 R2
How to easily install Microsoft SQL Management Studio 2008 R2 with direct download links and step by step instructions.
SQL Query – Find invalid email addresses
The article provides information on how to use an SQL query to identify invalid email addresses in a database, which can help improve data quality and prevent errors.