Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Regular Expression Expand / Collapse
Author
Message
Posted Tuesday, May 11, 2010 4:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 18, 2011 10:09 PM
Points: 5, Visits: 43
Can we write regular expression in sql server express 2005?

and can we use regular expression in creating search string?
Post #919559
Posted Thursday, May 20, 2010 5:44 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
nidhivarshney82 (5/11/2010)
Can we write regular expression in sql server express 2005?

and can we use regular expression in creating search string?


The short answer is yes. The Sql Clr is available in Sql Express as it is in other versions of Sql Server.
Post #925597
Posted Thursday, May 20, 2010 7:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 18, 2011 10:09 PM
Points: 5, Visits: 43
How can we use it in creating search query? Can you give me some examples?
Post #925634
Posted Friday, May 21, 2010 3:36 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
nidhivarshney82 (5/20/2010)
How can we use it in creating search query? Can you give me some examples?


Assuming:

1. You are comfortable coding in any one of the .Net Languages.
2. You have the necessary access rights to enable the CLR on the Sql Instance.

This should help:


http://msdn.microsoft.com/en-gb/magazine/cc163473.aspx
Post #926309
Posted Saturday, May 22, 2010 5:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 18, 2011 10:09 PM
Points: 5, Visits: 43
Thanks cK ...

That's the nice article..
Post #926399
Posted Saturday, May 22, 2010 8:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
Glad I could help :)
Post #926417
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse