Session variable vs. Stored Proc

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andy G (ajgould_at_iastate.edu)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 16:11:22 -0600

I have a registration page that captures 75% of the users data. After they
enter that info they are redirected to one of two pages depending on how
they answered a question on the registation page. My question is would it
be better to store all of the fields(15 or so) from the first page in
session variables and reference them from the next page and run ONE stored
procedure OR would it be better to run a stored procedure the first page and
then run an update procedure on the next page with the rest of the fields?
So it would be 15 session variables with 1 stored procedure or 1 stored
procedure with 1 update stored procedure?

Thanks

Relevant Pages

  • Re: Session variable vs. Stored Proc
    ... > the next page and run ONE stored procedure OR would it be better to ... > with 1 update stored procedure? ... to store the 15 values in 15 separate session variables: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Postback, session state ETC
    ... Private Sub GOButton_Click(ByVal sender As System.Object, ... The session variables are blank, ... >> using a stored procedure, the stored procedure uses the selectitem in ... >> the drop down boxes and the SEARCH button to be displayed, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Session variable vs. Stored Proc
    ... Hans that is a good idea. ... > Andy G wrote: ... >> so) from the first page in session variables and reference them from ... >> the next page and run ONE stored procedure OR would it be better to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Optimistic Concurrency - DataRow.Column Error Property Not Set
    ... > trap concurrency errors caused by an Update stored procedure, ... > fields within the WHERE clause of the UPDATE stored procedure. ... > using a DataAdapter to call the appropriate Select, Insert, Update, and ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Get Primary Key column
    ... >> I would like to write 1 stored procedure that can perform the same ... function on any table depending on the parameters I pass to it. ... Get ANY book on software engineering and look up cohesion. ... basic programmng principle and goes well beyond SQL. ...
    (microsoft.public.sqlserver.programming)