SQL

SELECT RoleP.name AS DatabaseRoleName ,ISNULL(UserP.name, ‘No members’) AS DatabaseUserName ,UserP.principal_id ,UserP.create_date FROM sys.database_role_members AS DRM RIGHT OUTER JOIN sys.database_principals AS RoleP ON DRM.role_principal_id = RoleP.principal_id LEFT OUTER JOIN sys.database_principals AS UserP ON DRM.member_principal_id = UserP.principal_id WHERE RoleP.type = ‘R’ and UserP.name = ‘my-name’ ORDER BY RoleP.name, ISNULL(UserP.name, ‘No members’);

CREATE FUNCTION dbo.UrlDecode(@url varchar(3072)) RETURNS varchar(3072) AS BEGIN DECLARE @count int, @c char(1), @cenc char(2), @i int, @urlReturn varchar(3072) SET @count = Len(@url) SET @i = 1 SET @urlReturn = ” WHILE (@i <= @count) BEGIN SET @c = substring(@url, @i, 1) IF @c LIKE ‘[!%]’ ESCAPE ‘!’ BEGIN SET @cenc = substring(@url, @i + … Read more

Version 2 CREATE FUNCTION dbo.UrlEncode(@url NVARCHAR(1024)) RETURNS NVARCHAR(3072)ASBEGIN DECLARE @count INT, @c NCHAR(1), @i INT, @urlReturn NVARCHAR(3072) SET @count = LEN(@url) SET @i = 1 SET @urlReturn = ” WHILE (@i <= @count) BEGIN SET @c = SUBSTRING(@url, @i, 1) IF @c LIKE N'[A-Za-z0-9()”*\-._!~]’ COLLATE Latin1_General_BIN ESCAPE N’\’ COLLATE Latin1_General_BIN BEGIN SET @urlReturn = @urlReturn … Read more

https://stackoverflow.com/questions/1024978/find-index-of-last-occurrence-of-a-sub-string-using-t-sql