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
 General SQL Server Forums
 New to SQL Server Programming
 Restrictions on fields output

Author  Topic 

sanj
Starting Member

22 Posts

Posted - 2008-12-24 : 07:45:39
Hi,

In Access there is a restriction on the number of fields you can output to a page (I think its 49), is there such a restriction in SQL?

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-24 : 07:55:11
quote:
Originally posted by sanj

Hi,

In Access there is a restriction on the number of fields you can output to a page (I think its 49), is there such a restriction in SQL?

Thanks



Your question is not clear.
Go to Top of Page

sanj
Starting Member

22 Posts

Posted - 2008-12-24 : 08:50:22
Apologies, I have an asp page with a query from an access db, the query involes about 49 fields but there is an error, which is a restriction for access db too many fields, o need to know whether ms SQL has the same restriction.

Go to Top of Page

raky
Aged Yak Warrior

767 Posts

Posted - 2008-12-24 : 08:53:17

Hi,

see this link

http://weblogs.sqlteam.com/mladenp/archive/2007/07/24/60267.aspx

Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-24 : 09:04:50
http://msdn.microsoft.com/en-us/library/ms143432.aspx
Go to Top of Page

sanj
Starting Member

22 Posts

Posted - 2008-12-24 : 09:32:42
thanks for the links
Go to Top of Page
   

- Advertisement -