PWORD Post

October 2006.  I created a program for tracking passwords which is still open source.  Its at www.sourceforge.net/projects/pword.   This project is perfect for keeping track of passwords b/c you can drag and drop the username and password from a treeview control.  Last I updated it was to change the + sign on the treeview control.  Wow that is neat.  I can also use it with Sql 2000 and up to store broken notes. 

...

for Regex I'm using in sql .

drop assembly RegEx

CREATE PWORD Post

October 2006.  I created a program for tracking passwords which is still open source.  Its at www.sourceforge.net/projects/pword.   This project is perfect for keeping track of passwords b/c you can drag and drop the username and password from a treeview control.  Last I updated it was to change the + sign on the treeview control.  Wow that is neat.  I can also use it with Sql 2000 and up to store broken notes. 

...

for Regex I'm using in sql .

drop assembly RegEx

ASSEMBLY RegEx from 'C:\tmp\RegEx.dll' WITH PERMISSION_SET = SAFE
go

CREATE function dbo.fnIsMatch(
    @input as nvarchar(50),
    
@pattern as nvarchar(50)
)
returns bit

AS

EXTERNAL
NAME RegEx.[RegEx.RX].IsMatch
go

CREATE function dbo.fnGetMatchCount(
    @input as nvarchar(50),
    @pattern as nvarchar(50)
)
returns int

AS

EXTERNAL NAME RegEx.[RegEx.RX].GetMatchCount
go

CREATE function dbo.fnGetMatch(
    
@input as nvarchar(50),
    
@pattern as nvarchar(50)
)
returns nvarchar(50)

AS

EXTERNAL NAME RegEx.[RegEx.RX].GetMatch
go

CREATE function dbo.fnGetAllMatches(
    
)

AS

EXTERNAL NAME RegEx.[RegEx.RX].GetMatch
go

CREATE @input as nvarchar(50),
    @pattern as nvarchar(50)
)
returns nvarchar(50)

AS

EXTERNAL NAME RegEx.[RegEx.RX].GetAllMatches
go

Reference is my favorite author ever MSDN. 
http://msdn.microsoft.com/en-us/library/ms131052.aspx

Had to enable clr to run a select statement:

sp_configure 'clr enabled', 1
go
reconfigure


See other article creating the VS2012 C# Library.