My recommendation will be just to use a set of record or table for output.
On Nov 26, 5:26 pm, Muhammad Arif <[email protected]> wrote: > 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
