More than 250 Columns in a view.

Article View: bit.databases.mssql-l

Article #49

Back to bit.databases.mssql-l Previous Next

#49

From: Enrique Sanchez
Date: Fri, 14 Jan 2000 00:00

13 lines
1608 bytes

Is there any way of creating a view with more than 250 columns in SQL Server
7.0?

I know there's a limit in tables of 1024 columns.
Is the same limit in Views?

Do I have to change something in the server configuration?

Thanks in advance!

Javier.
jdm@proinfo2000.com
Spain.

Technical Details

Message-ID: <85n4t9$o9h$1@diana.bcn.ttd.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 106afd,2ac45b769c61e186,start
X-Google-Attributes: gid106afd,public
X-Google-Thread: f4a41,2ac45b769c61e186,start
X-Google-Attributes: gidf4a41,public
X-Google-Thread: 1025cd,2ac45b769c61e186,start
X-Google-Attributes: gid1025cd,public
X-Google-Thread: 104de1,2ac45b769c61e186,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,2ac45b769c61e186,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 111a5a,2ac45b769c61e186,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 109585,2ac45b769c61e186,start
X-Google-Attributes: gid109585,public
X-Google-Thread: 106e2f,2ac45b769c61e186,start
X-Google-Attributes: gid106e2f,public
From: "Enrique Sanchez" <ejsm@proinfo2000.com>
Subject: More than 250 Columns in a view.
Date: 2000/01/14
Message-ID: <85n4t9$o9h$1@diana.bcn.ttd.net>
X-Deja-AN: 572532615
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Organization: Telefonica Transmision de Datos
X-MSMail-Priority: Normal
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver,es.comp.bd.misc,es.comp.bd.ms-access,es.comp.lenguajes.delphi,es.comp.os.ms-windows.misc,microsoft.public.de.sqlserver,microsoft.public.fr.sqlserver,microsoft.public.sqlserver.clients,microsoft.pu