Posted by Erland Sommarskog on 04/27/06 14:09

(peppi911@hotmail.com) writes:
> is it possible to create a cursor from a dynamic string?
> Like:
>
>
> DECLARE @cursor nvarchar(1000)
> SET @cursor = N'SELECT product.product_id
> FROM product WHERE fund_amt > 0'
>
> DECLARE ic_uv_cursor CURSOR FOR @cursor
>
> instead of using this
>
> --SELECT product.product_id
> --FROM product WHERE fund_amt > 0 -- AND mpc_product.status
>= 'aktiv'

Yes, this is possible, but the question remains: why?

See here for details: http://www.sommarskog.se/dynamic_sql.html.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Limits on rows in a table
• Prev in forum: Re: Disk or network error
• Thread view: Re: Declare dynamic Cursor from String

[Reply to this message]