Displaying page
of
pages;
Items to
|
Title |
Test
Details
SQL Object Name Match
|
|
Expression |
(((\[?(?<Database>[\w]+)\]?)?\.)?(\[?(?<Owner>[\w]+)\]?)?\.)?\[?(?<Object>[\w]+)\]?
|
|
Description |
This returns the different parts of an Object Name (Database.Owner.Object). This can be used for matching or pulling out the different pieces.
|
|
Matches |
[Table], Table, [Db].[Owner].[Table], [owner].[Table], ..[Table], or any combination there of...
|
|
Non-Matches |
None
|
|
Author |
Rating:
Not yet rated.
Tim McCurdy
|
|
Title |
Test
Details
SQL Column Matches
|
|
Expression |
((?<Owner>\[?[\w\d]+\]?)\.{1})?(?<Column>\[?[\w\d]+\]?)(\s*(([><=]{1,2})|(Not|In\(|Between){1,2})\s*)(?<Value>[\w\d\']+)
|
|
Description |
This expression finds all Column within a Select, Update, or Delete query (ex. Column1 = 2, Column2 = 3). This is useful if you need to refactor a SQL Statement to include a owner prefix before all columns but you aren't sure how many columns there are in the statement.
|
|
Matches |
Select ... Where (T.Column1 = @Value) ...Update Table1 Set Col1 = @Value
|
|
Non-Matches |
None
|
|
Author |
Rating:
Not yet rated.
Tim McCurdy
|
Displaying page
of
pages;
Items to
