Tim talks tech
Tag

SQL Server

#sql-server

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

Using SQL Server to manipulate JSON data structures, including a boolean gotcha

Aug 31, 20234 min read

The problem I was solving I recently did some work to update the structure of some JSON stored in a SQL Server database. The JSON started out as a...

Using SQL Server to manipulate JSON data structures, including a boolean gotcha

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