-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: RAJmtp
Message 9 in Discussion
New Message on MumbaiUserGroup
Running Stroed Procedure on Query Analyzer
Reply
Reply to Sender
Recommend
Message 5 in Discussion
From:
RAJmtp
New Message on MumbaiUserGroup
Running Stroed Procedure on Query Analyzer
Reply
Reply to Sender
Recommend
Message 4 in Discussion
From:
RAJmtp
New Message on MumbaiUserGroup
Running Stroed Procedure on Query Analyzer
Reply
Reply to Sender
Recommend
Message 1 in Discussion
From:
RAJmtp
Hi, I have a table like Page(nvarchar) Roles(nvarchar)
Rights(int) x 1 31 y
2 20 i m using query select Page,
Rights from TableName where User in (1,2) and Page=x then its run withoutht
any erro bu when i m ceating Store procedure for the above query as Creat
Procedure Name (
@page nvarchar(50),
@Role nvarchar(50)
)
AS
DECLARE @sql nvarchar(100)
SET rowcount 1
SET @sql = 'SELECT Rights, Page '
SET @sql = @sql + ' FROM Security'
SET @sql = @sql + ' WHERE [EMAIL PROTECTED] AND Role IN (' + @Role + ')
SET @sql = @sql + 'Order BY Rights Desc ' EXEC sp_executesql @sql
GO
and running on query analyzer then its show me error "MUST DECLARE VARIABLE
@PAGE" WHAT i m doing wrong plz help me for correct Procsedure for above
query thanks Raj
View other groups in this category.
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]
