Search for a command to run...
Articles tagged with #sql
I use JetBrains Rider as my primary IDE, and I like to use it for as much of my development process as possible. I prefer to avoid jumping around between multiple different applications if I can, so when I want to run some SQL I typically use Rider r...
Background I recently wrote an EF Core migration which included dropping an index. This index was somewhat unusual, as it didn’t follow our naming conventions and we didn’t know how it had been added. The disparity in naming suggested it may have bee...
I recently needed test data consisting of many locations with latitude and longitude defined. They needed to be within the UK, but also needed to be different from each other so I could calculate distances between them. I needed them in a SQL Server ...
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 column. You will have to drop the view, modify the column, then recreate the view. That's fine in pri...
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 simple enough task - throughout the SQL I wrote, I added to all the WHERE clauses this line: AND ISNULL([...
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 a query as part of that query. For example, to view the data inserted by an INSERT statement, you c...
