CREATE PROCEDURE [dbo].[Procedure]
@GroupId as varchar(500) = ''
SET NOCOUNT ON;
DECLARE @query as nvarchar(500)
set @query = 'select VideoTitle from Item where ItemId in(select ItemId from GroupLink
where GroupId in (' + @GroupId +'))'
exec SP_EXECUTESQL @query
Now execute the procedure as exec Procedure (2,3,4)
I used to do like the above whenever I have to retrieve the values based on a list...Don't know if it has any performance issues...
"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)
i have used aspnet authentication to logging into my site.When i click logout and i click back button,i can see the last page.How can i logout properly.I used FormsAuthentication.Signout() to logout.What is the problem of dont properly logout fro site.
Actually i put a login control in masterpage enabled page and i put menu in masterpage.in the menu i put a menuitem logout and in the menu item click event i given formsauthentication.signout and the above given code.and i retdirect the page to home page where the login control, is situated.This is the flow of login and logout.After logout i checked username is null or not in another menuitem page.but i can easily access the page because the username still exists.What is the problem.