Re: limitation in insert ... select
From: Daniel Clamage <dclamageNOSPAM_at_telerama.com>
Date: 12 Aug 1998 07:35:16 -0400
Message-ID: <01bdc5bb$221faf60$5929c9cd_at_saturn>
Date: 12 Aug 1998 07:35:16 -0400
Message-ID: <01bdc5bb$221faf60$5929c9cd_at_saturn>
The limit is the number of columns allowable per table, which I don't remember offhand.
-- - Dan Clamage http://www.telerama.com/~dclamage If you haven't crashed the Server, you haven't been trying hard enough. skgopa_at_my-dejanews.com wrote in article <6p7df3$kjt$1_at_nnrp1.dejanews.com>...Received on Wed Aug 12 1998 - 13:35:16 CEST
>
>
> Hi,
>
> Is there any limitation in the following statement
>
> INSERT INTO ABC
> SELECT *
> FROM DEF
> WHERE A='X';
>
> Tables ABC and DEF have the same number of columns and datatypes.
> No of columns is 200.
>
> Is there any limitation in the select clause as how many columns I can
select?
>
> Any help will be appreciated.
>
> - skgopa
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>