Regular expressions in Visual Studio
Here is a list of regular expressions that work for me in Visual Studio when locating/replacing text in SQL.
- generate scripts tasks for data will turn dates in to HEX. For example, it will turn a row_created_data column into CAST(0x000063DF01035C97 AS DateTime). I want to change those dates to GETDATE(): search for ‘CAST(0x:h AS DateTime)’ (:h searches for hex values)