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)

Comments Closed.