-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: USS103
Message 15 in Discussion
New Message on MumbaiUserGroup
Running Stroed Procedure on Query Analyzer
Reply
Reply to Sender
Recommend
Message 13 in Discussion
From:
USS103
New Message on MumbaiUserGroup
Running Stroed Procedure on Query Analyzer
Reply
Reply to Sender
Recommend
Message 11 in Discussion
From:
USS103
table strecture. CREATE TABLE [security] (
[Page] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[roles] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[rights] [int] NULL
) ON [PRIMARY]
GO
------------------------------------------------- Use this Stored Procedure.
create procedure myproc
@page nvarchar(50),
@Roles nvarchar(50)
AS
DECLARE @sql nvarchar(125)
SET rowcount 1
SET @sql = 'SELECT Rights, Page
FROM Security
WHERE Page= '''+ @page +''' AND Roles IN (' + @Roles + ')
Order BY Rights Desc'
exec(@sql)
GO
View other groups in this category.
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
