Do cursors use statistics?

Similar Threads:

1.use UPDATE STATISTICS @table in a cursor

The script below is a cursor. I get the following error when I run it:
--{Server: Msg 170, Level 15, State 1, Line 14
Line 14: Incorrect syntax near '@table'.}--
The error is caused by this phrase: -- UPDATE STATISTICS @table --  How do I
resolve this.

***********************************************************
SET NOCOUNT ON
USE db_control
DECLARE @table varchar(10)
DECLARE EDI_cursor CURSOR FOR
SELECT table_name FROM INFORMATION_SCHEMA.TABLES
WHERE table_type ='Base Table'
ORDER BY table_name
OPEN  EDI_cursor
FETCH NEXT FROM  EDI_cursor
INTO @table
WHILE @@FETCH_STATUS = 0
BEGIN
select @table
UPDATE STATISTICS @table
FETCH NEXT FROM EDI_cursor
   INTO @table
END
CLOSE EDI_cursor
DEALLOCATE EDI_cursor
GO
**********************************************************

2.mdac 2.8 fails to execute a cursor fetch next when done via oledb (repost)

I have an SQL script that uses a cursor to update some rows. I loop  
through all the records using 'fetch next from mycursor'.

This works fine when executed in SQL Query Analyzer. When sending the very  
same script via OLEDB to the SQL Server I get an unspecified OLEDB
error. I could locate the spot where the error occurs the first time, it's  
at the 'fetch next'.

I did not test all available MDAC versions. But I succeeded with versions  
2.6 and 2.7SP1. Version 2.8, the latest one, gives me troubles.

Any hints, insights?

TIA
Rudi Wiener

3.Can this be done without a cursor?

Here's the senario.  I have a list of users who have received services
during the year.  I need a report that gives me the languages they speak
both year to date and month to date.  The challenge for me is to figure out
how to output something like this:

Language  MTD   YTD
English         2         2
French         0         1
German       1         1
Spanish       2          2

Here's some DDL:

CREATE TABLE #Services (
 UserId int,
 svcDate datetime
)

INSERT INTO #Services VALUES (1, '1/3/2003')
INSERT INTO #Services VALUES (2, '3/1/2003')
INSERT INTO #Services VALUES (2, '4/1/2003')
INSERT INTO #Services VALUES (3, '2/1/2003')
INSERT INTO #Services VALUES (4, '3/27/2003')
INSERT INTO #Services VALUES (3, '4/22/2003')

CREATE TABLE #Languages (
 UserID int,
 Language varchar(50)
)

INSERT INTO #Languages VALUES (1, 'French')
INSERT INTO #Languages VALUES (2, 'English')
INSERT INTO #Languages VALUES (3, 'Spanish')
INSERT INTO #Languages VALUES (4, 'German')

SELECT
 COUNT(a.UserID),
 b.Language
FROM #Services AS a
LEFT JOIN #Languages AS b ON a.UserId = b.UserId
WHERE a.svcDate >= '1/1/2003'
GROUP BY b.Language
ORDER BY b.Language

SELECT
 COUNT(a.UserId),
 b.Language
FROM #Services AS a
LEFT JOIN #Languages AS b ON a.UserId = b.UserId
WHERE a.svcDate >= '2/1/2003'
GROUP BY b.Language
ORDER BY b.Language

This gives me two separate tables but I want just one output as above.  Can
this be done without using a cursor?  Thanks.

4.mdac 2.8 fails to execute a cursor fetch next when done via oledb

I have an SQL script that uses a cursor to update some rows. I loop  
through all the records using 'fetch next from mycursor'.

This works fine when executed in SQL Query Analyzer. When sending the very  
same script via OLEDB to the SQL Server I get an unspecified OLEDB error.  
I could locate the spot where the error occurs the first time, it's at the  
'fetch next'.

I did not test all available MDAC versions. But I succeeded with versions  
2.6 and 2.7SP1. Version 2.8, the latest one, gives me troubles.

Any hints, insights?

TIA
Rudi Wiener

5.using a cursor with a cursor in transact-sql

6. using a cursor vs using a query

7. Deletion using multiple records without using cursor

8. Auto created statistics and missing statistics