Archives of the TeradataForum
Message Posted: Fri, 20 Feb 2004 @ 15:16:43 GMT
I have created a table with 2 fields , both having datatype as integer using :-
create table temp1(id1 integer , val1 integer) ;
After creating the table when I try to insert records in the table using
1) Insert into temp1 (id1,val1) values (1,2);
2 ) Insert into temp1 values (1,2);
Both of the above insert statements returns an error saying " too many values ".
However if I try to insert using following :-
3) Insert into temp1 select 1,2
It works fine.
Can anyone explain why first two insert statement does not work.
Thanks and Regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|