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
ASSEMBLY RegEx
from 'C:\tmp\RegEx.dll'
WITH PERMISSION_SET
= SAFE CREATE
function dbo.fnIsMatch( AS CREATE
function dbo.fnGetMatchCount( AS EXTERNAL
NAME RegEx.[RegEx.RX].GetMatchCount CREATE
function dbo.fnGetMatch( AS EXTERNAL
NAME RegEx.[RegEx.RX].GetMatch CREATE
function dbo.fnGetAllMatches(
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
go
@input
as nvarchar(50),
@pattern
as nvarchar(50)
)
returns bit
EXTERNAL
NAME RegEx.[RegEx.RX].IsMatch
go
@input
as nvarchar(50),
@pattern
as nvarchar(50)
)
returns int
go
@input
as nvarchar(50),
@pattern
as nvarchar(50)
)
returns
nvarchar(50)
go
)
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.