How is above error and cursor related?

Thanks all! This was a good discussion.

My options are Method 2 and Method 3, I'll choose #3 (SELECT * query) because it is simple and AFAIK I would get similar...

grahamc (12/15/2010)

---

If you plan on use Dynamic SQL, how are the new columns created? If the users are able to create them and name them however they want, use the...

Resender (12/15/2010)

---

I've been taught to avoid the use of select all, so method 2 is indeed one way you could do it.

However a table that changes a lot getting new...

Jeff Moden (12/14/2010)

---

Please understand that that's usually a bad thing to do because it makes it real...

CirquedeSQLeil (12/14/2010)

---

I would avoid the Select * method. Are you absolutely certain that all of the code has been adapted to properly handle all of the columns? Do...

GSquared (12/14/2010)

---

This actually begs the question of why the number of columns in a table is so volatile that this matters in the first place.

In most cases, the properties of...

WayneS (12/14/2010)

---

ASDL (12/14/2010)

---

My question still holds how do I write this SP so that I do not have to change it in future if columns are added or deleted from...

sturner (12/14/2010)

---

All columns will always be returned by " select * " in the order of the original CREATE TABLE statement. If the table has many and/or large columns and...

Are you referring to Spotlight from Quest Software?

http://www.quest.com/spotlight-on-sql-server-enterprise/

sturner (12/14/2010)

---

If the intention of the query is to return most if not all of the columns from the table, and the order nor the exact number is important to...

Need more information to answer this.

Looking at above statement looks like you have not declared the variables.

Thanks for your reply!

If I need to select all columns from a table, I think SELECT * should work here. In my opinion Method 2 is an overkill. Moreover, the...

I don't understand.

Are you...

Yes, I did. I will not be able to use that as data has to be written in specific CSV format.

Some fields will be in quotes, some not - and...