what i am thinking that.. out parameter with user result that .. user can be checked on each page or forms for permission pupose..
2. out parameter with password may be used when the session time out occur so the user have to again give user name and password.. so i will not connect with db again but will check with those which is already get first.. On Thu, Nov 26, 2009 at 11:21 AM, Raghupathi Kamuni <[email protected]>wrote: > > @user varchar output, > > @password varchar output > > Why do you need output parameters here ? > > On Thu, Nov 26, 2009 at 5:02 AM, sso <[email protected]> wrote: > >> I have a stored procedure (show below) that I need to return a few of >> the fields. Its just a basic login, nothing high security. I can't >> figure out how to get it to return the fields I require. Any >> assistance? (I'm using C# and SQL Express 2008). >> >> Kind regards. >> Thanks! >> >> >> >> >> >> >> ALTER PROCEDURE [dbo].[auth] >> -- Add the parameters for the stored procedure here >> ( >> @user varchar output, >> @password varchar output >> ) >> AS >> DECLARE >> @id int, >> @pos varchar >> >> >> BEGIN >> -- SET NOCOUNT ON added to prevent extra result sets from >> -- interfering with SELECT statements. >> SET NOCOUNT ON; >> >> -- Insert statements for procedure here >> SELECT PersonID, Rank, Position, Supervisor FROM PERSON WHERE >> UserName = @user AND Password = @password >> END >> > > -- Senior Software Engineer
