{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 欢心 的问题《SQL Server 2005 - How can I do a Reg Exp in T-SQL》','https://www.manongdao.com/q-892868.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Is there any way I can perform a Regular Expression search using T-SQL in SQL Server 2005 without having to load a .Net Assembly?
相关问题
- Improve converting string to readable urls
- keeping one connection to DB or opening closing pe
- Regex to match charset
- Regex subsequence matching
- Accommodate two types of quotes in a regex
相关文章
- Optimization techniques for backtracking regex imp
- Regex to check for new line
- Allow only 2 decimal points entry to a textbox usi
- Comparing speed of non-matching regexp
- Regular expression to get URL in string swift with
- 请问如何删除之前和之后的非字母中文单字
- Convert column to string in SQL Select
- Lazy (ungreedy) matching multiple groups using reg
Unfortunately, the only way I know is by using a CLR udf as described in http://msdn.microsoft.com/en-us/magazine/cc163473.aspx
Dan Farino seems to have written an SP for SQL Server exactly for the purpose of using regex without having to install a .NET framework for CLR. Looks promising.
It seems that you can do it with VBScript, but it's not very pretty.