Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Open and Fetch without specifying column name

Author  Topic 

ryanlcs
Yak Posting Veteran

62 Posts

Posted - 2010-10-04 : 02:30:40
Hi

Is there a way to open and fetch a cursor of a select statement, but without specifying the column name. Such as Select * From Table A.
But I want the Fetch function to be able to split all the columns.

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-10-04 : 09:54:42
why do you need a cursor in first place? are you sure you wont be able to achieve your solution using any set based technique?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -