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!!!!