what's wrong with this code?
Posted
by user329820
on Stack Overflow
See other posts from Stack Overflow
or by user329820
Published on 2010-04-30T19:12:00Z
Indexed on
2010/04/30
19:17 UTC
Read the original article
Hit count: 221
Hi this is my code which will not work correctly ! what is wrong with its data type :( thanks
CREATE TABLE T1 (A INTEGER NOT NULL);
CREATE TABLE T3 (A SMALLINT NOT NULL);
INSERT T1 VALUES (32768.5);
SELECT * FROM T1;
INSERT T3 SELECT * FROM T1;
SELECT * FROM T3;
© Stack Overflow or respective owner