<div>
Why not use the declare for a variable and then add if statements. If you do this within a sp you can call it and pass in the DB Name you want to use.
</div>


Why not use the declare for a variable and then add if statements. If you do this within a sp you can call it and pass in the DB Name you want to use.

<div>
<div class="content wysiwyg-content">
Is it possible to do this with a regular expression replacement?<br />
<br />
I have a SQL string and it looks something like this:<br />
<br />
SELECT field1, field2, field3<br />
FROM dbo.BLAH_ABC_TABLE1<br />
INNER JOIN dbo.FOO_BAR_TABLE2 on dbo.FOO_BAR_TABLE2.myfield<wbr /> = field1<br />
INNER JOIN dbo.ABC_TABLE3 on dbo.ABC_TABLE3.myfield2 = field1<br />
ORDER BY dbo.BLAH_ABC_TABLE1.myfiel<wbr />d<br />
<br />
Anywhere where there is &quot;dbo.XXX_YYY_ZZZZ&quot; I need to replace it with &quot;dbo.ZZZZ&quot;. e.g.<br />
&nbsp; &nbsp; &nbsp; &quot;dbo.AAA_BBB&quot; gets changed to &quot;dbo.BBB&quot;<br />
&nbsp; &nbsp; &nbsp; &quot;dbo.AAA_BBB_CCC_DDD&quot; gets changed to &quot;dbo.DDD&quot;<br />
&nbsp; &nbsp; &nbsp; &quot;dbo.TEST&quot; remains unchanged.<br />
<br />
So for example, the above string would be converted into<br />
<br />
SELECT field1, field2, field3<br />
FROM dbo.TABLE1<br />
INNER JOIN dbo.TABLE2 on dbo.TABLE2.myfield = field1<br />
INNER JOIN dbo.TABLE3 on dbo.TABLE3.myfield2 = field1<br />
ORDER BY dbo.TABLE1.myfield
</div>
</div>


Is it possible to do this with a regular expression replacement?

I have a SQL string and it looks something like this:

SELECT field1, field2, field3
FROM dbo.BLAH_ABC_TABLE1
INNER JOIN dbo.FOO_BAR_TABLE2 on dbo.FOO_BAR_TABLE2.myfield = field1
INNER JOIN dbo.ABC_TABLE3 on dbo.ABC_TABLE3.myfield2 = field1
ORDER BY dbo.BLAH_ABC_TABLE1.myfield

Anywhere where there is "dbo.XXX_YYY_ZZZZ" I need to replace it with "dbo.ZZZZ". e.g.
      "dbo.AAA_BBB" gets changed to "dbo.BBB"
      "dbo.AAA_BBB_CCC_DDD" gets changed to "dbo.DDD"
      "dbo.TEST" remains unchanged.

So for example, the above string would be converted into

SELECT field1, field2, field3
FROM dbo.TABLE1
INNER JOIN dbo.TABLE2 on dbo.TABLE2.myfield = field1
INNER JOIN dbo.TABLE3 on dbo.TABLE3.myfield2 = field1
ORDER BY dbo.TABLE1.myfield

Regular expression to trim prefix from a name

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.

Regular Expressions

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.