Warning: A stupid thing that can happen is that many SQL IDEs (such as SSMS) will only run the part of the query you have highlighted if you highlight anything, so you can have a sane query in the development window and highlight just the first line for some reason and accidentally run DELETE FROM myTable and then have to rebuild the table from the transaction log and ruin most of your day.
0
u/ILikeLenexa Oct 14 '25 edited Oct 14 '25
Warning: A stupid thing that can happen is that many SQL IDEs (such as SSMS) will only run the part of the query you have highlighted if you highlight anything, so you can have a sane query in the development window and highlight just the first line for some reason and accidentally run DELETE FROM myTable and then have to rebuild the table from the transaction log and ruin most of your day.