Limitation on number of columns in Visual Studio 2008

visual studio server MS SQL Server

I am working on Visual Studio 2008 server and tried to fetch rows from the database but I am hitting an error indicating more than 655 columns. Is there any limit for the number of columns a table I can fetch in my query? Is there any way I can retrieve these much number of columns?

0 0

1 Answer

usharani

Answered on 13th Dec, 2017

This limitation is for Visual Studio. You would require writing separate queries to get different columns and combine the output by comparing common columns.

0 0

Would you like to add a better answer?

Limitation on number of columns in Visual Studio 2008

Follow

Newsletter