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!!!!
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sanwar RanwaPosted Apr 12, 2019, 1:34 AM
Nandha Kumar NagarajanPosted Apr 12, 2019, 2:48 AM