Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Feb 2004 @ 15:16:43 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Insert Values problem
 
From:   Agarwal, Rachana

Hi,

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);

OR

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,

Rachana



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016