Re: error in executing SELECT statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Olu Adedeji (i-oluade_at_microsoft.com)
Date: 01/01/05

Next message: Olu Adedeji: "Re: Problems with T-SQL in SQL Job"
Previous message: Gert-Jan Strik: "Re: SQL 2000 slowness!"
In reply to: Dzemo: "error in executing SELECT statement"
Next in thread: AnthonyThomas: "Re: error in executing SELECT statement"
Reply: AnthonyThomas: "Re: error in executing SELECT statement"
Messages sorted by: [ date ] [ thread ]

Date: Sat, 1 Jan 2005 01:19:14 -0000

is this a large table(how big is the table - rows, data types)?
possible disk controller issue?

"Dzemo" <dzemo@wizard.ba> wrote in message
news:eLgrfcy7EHA.3840@tk2msftngp13.phx.gbl...
> I get this message when executing SELECT statement in SQL 2000:
>
> Location: recbase.cpp:1374
> Expression: m_nVars>0
> S PID: 51
> Process ID: 2480
>
> Why? Any help?
>
>

Next message: Olu Adedeji: "Re: Problems with T-SQL in SQL Job"
Previous message: Gert-Jan Strik: "Re: SQL 2000 slowness!"
In reply to: Dzemo: "error in executing SELECT statement"
Next in thread: AnthonyThomas: "Re: error in executing SELECT statement"
Reply: AnthonyThomas: "Re: error in executing SELECT statement"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

RE: Possible to get field names and types in a table without executing a query?
... preparing and executing a query against a table first. ... respective data types. ... This seams like wasted overhead since I don't use the ... I'm not sure what your objection to WHERE clauses is... ...
(perl.dbi.users)
Re: Struggling w/ the IIF function
... Where are you executing this lot from? ... from a query. ... What are the data types and expected values of each operator? ... Microsoft Access 2003 VBA Programmer's Reference ...
(microsoft.public.access.gettingstarted)
NVARCHAR2 gives error with Oracle8.1.7
... Unicode Data Types NVARCHAR2. ... On executing the application, I receive ...
(comp.databases.oracle.misc)