Tim talks tech
Tag

SQL

#sql

More content

Read more stories on Hashnode

Articles with this tag

Find SQL Server views which depend on a specific table column

Nov 15, 20233 min read

If you want to modify a column in an existing SQL Server database, but there is a View using that column, you will find you are unable to modify the...

Find SQL Server views which depend on a specific table column

Worked example - Using regex to refine a SQL script

Mar 29, 20232 min read

I was recently asked to copy some data in a SQL Server database but to exclude records which had the words 'To Delete' in their names. This is a...

Worked example - Using regex to refine a SQL script

Using OUTPUT clauses to check data changes in a SQL script

Mar 6, 20232 min read

A colleague recently showed me the OUTPUT clause in SQL Server, which I wasn't familiar with. It allows you to view the data which has been changed by...

Using OUTPUT clauses to check data changes in a SQL script

Worked example - Reversing the order of lines of text in a file

Feb 9, 20223 min read

How the need to convert a script for creating database views into a script to drop them led me to a useful powershell snippet ยท I recently wanted to...

Worked example - Reversing the order of lines of text in a file