insertion values in table

Question

 

hi friends ..

 

  This is my table 

 

CREATE TABLE STAT_PRODUCT

(

I_PRODUCT_ID INT IDENTITY,

VC_PRODUCT_NAME VARCHAR(10),

VC_PRODUCT_PRICE VARCHAR(10),

)

 

----------------insert query----------------------------------------------

  

INSERT INTO STAT_PRODUCT (I_PRODUCT_ID,VC_PRODUCT_NAME,VC_PRODUCT_PRICE)

SELECT 101,'PENCIL',5, UNION all;

 above format is executed is was an occured an error neat all i don't know  what is that can tell me anyone!!!!