SQL Server Performance Forum – Threads Archive

Table variable problem

I am implementing Pagination in ASP pages using table variable in sql stmt.
SQL stmt exports all rows to the table variable,then using given parameters
records are extracted for the required page(Page which user has clicked on) from table variable.
Here ASP page is used by 1000+ users,and upon clicking the same page server process in sql server is get locked.
as result of it users are getting error messages.
Using dynamic name for table var(string containing current data time in milli seconds) is not working.
Kindly suggest a solution
uss
uss

---

Don’t use a dynamic name for the table variable???? Do you really mean a table variable? DECLARE @table TABLE (col1 INT) MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

---

Why can’t you use a recordset for this.

---

]]>