November 13, 2013 at 10:21 pm
Comments posted to this topic are about the item REGEX
November 14, 2013 at 12:29 am
Great question, thanks.
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
Hall of Fame
November 14, 2013 at 12:51 am
November 14, 2013 at 12:56 am
In SQL Server, regular expressions really are poor.
November 14, 2013 at 1:07 am
This was removed by the editor as SPAM
November 14, 2013 at 2:19 am
As far as I know SQL Server can only handle REGEX via the CLR, so .NET.
The queries as shown here were not using REGEX.
Right there with Babe
November 14, 2013 at 2:28 am
Mighty (11/14/2013)As far as I know SQL Server can only handle REGEX via the CLR, so .NET.The queries as shown here were not using REGEX.
This was a really good question to test understanding of SQL string pattern matching (thanks Steve!) but I don't believe it strictly counts as Regex.
November 14, 2013 at 4:19 am
alex.d.garland (11/14/2013)Mighty (11/14/2013)As far as I know SQL Server can only handle REGEX via the CLR, so .NET.The queries as shown here were not using REGEX.+1This was a really good question to test understanding of SQL string pattern matching (thanks Steve!) but I don't believe it strictly counts as Regex.
Well, surely some of it is the nearest thing T-SQL has to REGEX? Maybe some of it really is too unlike REGEX to be thought of that way, but definitely some of it isn't.
November 14, 2013 at 6:42 am
Excellent question. Simply explained and good references. Thanks!
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]Connect to me on LinkedIn
November 14, 2013 at 7:56 am
Stewart "Arturius" Campbell (11/14/2013)Agree with the point regarding regex in T-SQL. .Net is definitely much more efficient in this regard...
Stewart "Arturius" Campbell (11/14/2013)
+1 Thanks for the great question.
November 14, 2013 at 10:11 am
Simple question but lots of mental work. Thanks, Steve!
November 14, 2013 at 2:48 pm
Cool question, thanks.
-------------------A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 15, 2013 at 12:17 am
What do you mean with that? As far as I understand, the examples did use regular expressions - a very limited form though.
November 15, 2013 at 12:29 am
Good question Steve. It gave me little hard time. 🙂
December 20, 2013 at 2:34 am
good question !
eliminating possibilities one by one give a good guess
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply