Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Regular Expressions Rss

   Items 1 to 6 of 6   
 

Using Regular Expressions to Convert PL/SQL code to T-SQL

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...
By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions
Rating: |  Discuss |   Briefcase | 9,462 reads

RegEx for DBAs

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions  Read more...
By David Poole 2012/05/08 | Source: SQLServerCentral.com | Category: regex
Rating: |  Discuss |   Briefcase | 10,072 reads

Using Regular Expressions to Convert PL/SQL code to T-SQL

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...
By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions
Rating: |  Discuss |   Briefcase | 9,462 reads

How To Use Regular Expressions for Data Validation and Cleanup

You need to provide data validation at the server level for complex strings like phone numbers, email addresses, etc. You may also need to do data cleanup / standardization before moving it from source to target. Although SQL Server provides a fair number of string functions, the code developed with these built-in functions can become complex and hard to maintain or reuse.  Read more...
By Additional Articles 2011/03/03 | Source: MSSQLTips.com | Category: regular expressions
Rating:  Rate this |   Briefcase | 14,545 reads

RegEx-Based Finding and Replacing of Text in SSMS

So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that could be made much quicker and easier by using the Regular-Expression-based Find/Replace functionality. It is understandable, since the syntax is odd and some features are missing, but it is still worth knowing about.   Read more...
By Additional Articles 2011/02/04 | Source: SimpleTalk | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,465 reads

TSQL Regular Expression Workbench

This Workbench is about using Regular expressions with SQL Server via TSQL. It doesn't even attempt to teach how regular expressions work or how to pull them together. There are plenty of such resources on the Web. The aim is to demonstrate a few possibilities and try to persuade you to experiment with them if you don't already use Regex with SQL Server.  Read more...
By Additional Articles 2007/12/10 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,966 reads
   Items 1 to 6 of 6   
 
Tags
sqlclr (2)    
t-sql (2)    
data warehouse (1)    
management studio (ssms) (1)    
oracle (1)    
pl/sql (1)    
regex (1)