Skip to content
The following steps detail how to create a read-only user for an SQL database using Microsoft SQL Server Management Studio....
If you’re building a string using an SQL statement, you can split results with “new lines” using CHAR() to insert...
When using SQL Management Studio you can right-click on a database table or view and select or edit, however by...
As a database administrator one simple health check you can perform on the information in the database is that dollars...
SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it...
When building complicated SQL statements often I will make use of a SELECT – FOR XML PATH statement to concatenate...
Problem When running an SQL view using SQL Management Studio you experience the following message: MSG 8134, Level 16, State...
Senario You have a ‘datetime’ field in an SQL server database table and need it to automatically use the current...
When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01...
As a database administrator one of the important data health checks you can perform is checking that email addresses being...
Here’s a little trick you can use to return TRUE/FALSE if a query has returned results. For example if a...
Below you’ll find two ways to search an SQL table column for a case insensitive string. Both examples use the...
The following shows how use a simple SQL statement to create a list of unique values and a count of...
SQL Management Studio allows you to open a table in design mode, make changes then generate a “change script”. The...
The following SQL statement shows how to combine a column into a single text string – separated by a comma....
Problem When designing a table you’re unable to save the changes. When you try you receive the following message: Saving...
The following example shows how to use a regular expression (a regex) to search for information in an SQL database....
The following SQL shows how to get the current financial year using SQL. This assumes that the financial year for...
Problem If you try to use a column alias in a where statement, you recieve an error message that reads...
The following T-SQL statement shows how output the name of a day from a date. For example, 16 March 2019...
The following SQL statement shows how to copy the data from one column to another. It will replace any existing...
The following SQL can be used to remove leading and trailing spaces from a columns values. Ideally the system that...
The following T-SQL shows how to reset a tables identity auto increment back the last available number. This may be...
The following T-SQL for Microsoft SQL Server shows how to find and replace text in a string. In this example we’ll change...
The following T-SQL statement shows how output a number as an ordinal number (st, nd, rd, th). For example, 3...
The following T-SQL for Microsoft SQL Server shows how to search for accented text without having to use the accented characters in...
Problem When attempting to delete a database table row using SQL Management Studio you receive the following error message: No...
The following SQL statement shows how to take a decimal value, e.g. 1234567.89 and convert it to a space delimited...
The following T-SQL statement shows how output the day from a date as an ordinal number (st, nd, rd, th)....
The following T-SQL shows how to reset a tables identity auto increment back to 1. This may be useful if...
The following SQL shows how to select a row from a table using the current financial year as the WHERE...
The following SQL shows how to select a row from a table using the current year as the WHERE condition....
There are many commercial tools to help you design and test SQL statements, as well as the execution tests in...
The following SQL command can be used in SQL Management Studio to change a column from varchar(x) to varchar(MAX). ALTER...
The following T-SQL for Microsoft SQL Server shows how to convert line separated text to comma separated text. For example, if we...
The following T-SQL shows how to update a value using the results of a SELECT query. This applies to Microsoft...
The following T-SQL statement shows how output the day from a date. For example, 16 March 2019 would output 16....
The following T-SQL statement shows how output the name of the month from a date. For example, 16 March 2019...