T-SQL stored procedure: Analyze permission storage and page correspondence

Create procedure w_function_getparams
As
Declare
@ Functionname_cn nvarchar (64 ),
@ Actionname nvarchar (32 ),
@ Pagename nvarchar (128 ),
@ Cache_fn nvarchiar (256 ),
@ Lenfn int,
@ Index_a int,
@ Index_ B int
Begin
Create Table # temp_tab
(
Id int identity (1, 1 ),
FN nvarchar (64 ),
An nvarchar (32 ),
Pn nvarchar (128)
)

Declare fn_cursor cursor
Select functionname from admin_functionlist where groupid = 0

Open fn_cursor;
Fetch next from fn_cursor into @ cache_fn;

While @ fetch_status = 0
Begin
Set @ lenfn = Len (@ cache_fn );
Set @ index_a = charindex ('|', @ cache_fn );
Set @ index_ B = charindex (':', @ cache_fn );

Set @ functionname_cn = substring (@ cache_fn, 0, @ index_a );
Set @ actionname = substring (@ cache_fn, @ index_a + 1, @ index_ B-@ Index_A-1 );
Set @ pagename = substring (@ cache_fn, @ index_ B + 1, @ lenfn-@ index_ B );

-- Print (@ functionname_cn );
-- Print (@ actionname );
-- Print (@ pagename );

Insert into # temp_tab values (@ functionname_cn, @ actionname, @ pagename)

Fetch next from fn_cursor into @ cache_fn;
End

Close fn_cursor;
Deallocate fn_cursor;

Select FN, An, PN from # temp_tab group by PN, An, FN

End

Data format:

Edit product information | EDIT: w_product_edit.aspx