use string to create cursor

Article View: bit.databases.mssql-l

Article #158

Back to bit.databases.mssql-l Previous Next

#158

From: Oliver Davitt
Date: Wed, 07 Mar 2001 06:06

5 lines
1989 bytes

is it possible to use a string to create a cursor in p-sql, e.g. set strSQL
= "select * from tbltest wher id in (" +strlist + ")"
declare crstest cursor as strSQL.

Any help would be much appreciated

Technical Details

Message-ID: <unkp6.7883$r4.7437@news.indigo.ie>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!freenix!codeine.org!grolier!dispose.news.demon.net!demon!diablo.theplanet.net!news.indigo.ie!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f589c,9700485597e1bb5e,start
X-Google-Attributes: gidf589c,public
X-Google-Thread: 11453f,9700485597e1bb5e,start
X-Google-Attributes: gid11453f,public
X-Google-Thread: 1083b9,9700485597e1bb5e,start
X-Google-Attributes: gid1083b9,public
X-Google-Thread: 104de1,9700485597e1bb5e,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: 12fc46,9700485597e1bb5e,start
X-Google-Attributes: gid12fc46,public
X-Google-Thread: f6611,9700485597e1bb5e,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 1131f0,9700485597e1bb5e,start
X-Google-Attributes: gid1131f0,public
X-Google-Thread: f58a3,9700485597e1bb5e,start
X-Google-Attributes: gidf58a3,public
X-Google-ArrivalTime: 2001-03-06 22:18:11 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!freenix!codeine.org!grolier!dispose.news.demon.net!demon!diablo.theplanet.net!news.indigo.ie!not-for-mail
From: "Oliver Davitt" <davitto@eircom.net>
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver,microsoft.beta.sqlserver7.OLAPAddins,microsoft.private.directaccess.sqlserver,microsoft.private.sqlserver7.olap,microsoft.private.SQLServer7.Server,microsoft.public.access.modulesdaovba,microsoft.pu
Subject: use string to create cursor
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <unkp6.7883$r4.7437@news.indigo.ie>
Date: Wed, 7 Mar 2001 06:06:15 -0000
NNTP-Posting-Host: 159.134.254.79
X-Complaints-To: abuse@eircom.net
X-Trace: news.indigo.ie 983945818 159.134.254.79 (Wed, 07 Mar 2001 06:16:58 BST)
NNTP-Posting-Date: Wed, 07 Mar 2001 06:16:58 BST
Organization: Eircom.Net http://www.eircom.net