limitation in insert ... select

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 Received on Thu Jul 23 1998 - 15:22:42 CEST