creating a SP


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: creating a SP

  1. #1
    Join Date
    Jul 2008
    Posts
    32

    creating a SP

    hitting a DB everytime on every navigation wont it cause performance issue

    as i fetch data only as per request

    this is the
    Code:
    @items varchar(5000),
        @status varchar(50),
        @ totalRowsInPage varchar(50),
        @finishedrecords varchar(50),
        @condition varchar(5000)
    
    -- my  Session["condition"] contain WHERE 1=1 AND
    
     " SELECT  *  from (select top    " + totalRowsInPage.ToString() + "  *  from
    (select top (" + finishedrecords.ToString() + ")" + Session["items"] + "  from EMPLOYEE
     Session["condition"]
                   
                    order byNAME )
      as T1 order by T1.NAME  DESC) as T2 ";
    
    order by NAME  ASC
    getting erroe
    Last edited by Hack; 03-06-2012 at 01:38 PM. Reason: Added Code Tags

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    What is the error?

Similar Threads

  1. Slight problem when creating sessions
    By davesd in forum Web
    Replies: 4
    Last Post: 06-06-2008, 02:08 PM
  2. Replies: 0
    Last Post: 04-24-2002, 05:01 PM
  3. Creating a session (newbie):
    By Jay in forum ASP.NET
    Replies: 2
    Last Post: 04-05-2002, 01:43 PM
  4. Defining & Creating views
    By neil in forum Database
    Replies: 2
    Last Post: 07-04-2001, 08:07 AM
  5. ADOX - creating tables
    By Lenny in forum VB Classic
    Replies: 2
    Last Post: 03-21-2000, 05:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center