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.
2013-04-19 (first published: 2011-10-11)
9,656 reads
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.
2011-03-03
15,100 reads
By Brian Kelley
I recently received the news that I’ve been renewed as a Friend of Red...
I’ve been very blessed to be able to work for Redgate Software. We’ve done...
Extended Events can do things that simply are not possible with Profiler and another...
I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...
Hi, I want to run the below query to get information about the tables...
Hello SSC, I am looking for a simplified way to track which user created...
Ask SSC