COMBINATION_ACIL contains column:
id (primary)
prodcode
[group]
alias
lastupdate
updateby
and here is the steps when i import xml to sql
DECLARE @COMBINATION_ACIL AS xml
SET @COMBINATION_ACIL = '
<Product>
<product>
<PRODCODE>CADB</PRODCODE>
<GROUP>CADB</GROUP>
<ALIAS>ADB</ALIAS>
</product>
<product>
<PRODCODE>CI50</PRODCODE>
<GROUP>CI50</GROUP>
<ALIAS>I50</ALIAS>
</product>
<product>
<PRODCODE>CI80</PRODCODE>
<GROUP>CI80</GROUP>
<ALIAS>I80</ALIAS>
</product>
<product>
<PRODCODE>HOSBA</PRODCODE>
<GROUP>HOSB</GROUP>
<ALIAS>HOSBA</ALIAS>
</product>
<product>
<PRODCODE>HOSBB</PRODCODE>
<GROUP>HOSB</GROUP>
<ALIAS>HOSBB</ALIAS>
</product>
<product>
<PRODCODE>HOSBC</PRODCODE>
<GROUP>HOSB</GROUP>
<ALIAS>HOSBC</ALIAS>
</product>
<product>
<PRODCODE>HOSBD</PRODCODE>
<GROUP>HOSB</GROUP>
<ALIAS>HOSBD</ALIAS>
</product>
<product>
<PRODCODE>HOSBE</PRODCODE>
<GROUP>HOSB</GROUP>
<ALIAS>HOSBE</ALIAS>
</product>
<product>
<PRODCODE>HOSBF</PRODCODE>
<GROUP>HOSB</GROUP>
<ALIAS>HOSBF</ALIAS>
</product>
<product>
<PRODCODE>HOSBG</PRODCODE>
<GROUP>HOSB</GROUP>
<ALIAS>HOSBG</ALIAS>
</product>
<product>
<PRODCODE>HOSPA</PRODCODE>
<GROUP>HOSP</GROUP>
<ALIAS>HOSPA</ALIAS>
</product>
<product>
<PRODCODE>HOSPB</PRODCODE>
<GROUP>HOSP</GROUP>
<ALIAS>HOSPB</ALIAS>
</product>
<product>
<PRODCODE>HOSPC</PRODCODE>
<GROUP>HOSP</GROUP>
<ALIAS>HOSPC</ALIAS>
</product>
<product>
<PRODCODE>HOSPD</PRODCODE>
<GROUP>HOSP</GROUP>
<ALIAS>HOSPD</ALIAS>
</product>
<product>
<PRODCODE>HOSPE</PRODCODE>
<GROUP>HOSP</GROUP>
<ALIAS>HOSPE</ALIAS>
</product>
<product>
<PRODCODE>PW55</PRODCODE>
<GROUP>PW</GROUP>
<ALIAS>PW55</ALIAS>
</product>
<product>
<PRODCODE>PW60</PRODCODE>
<GROUP>PW</GROUP>
<ALIAS>PW60</ALIAS>
</product>
<product>
<PRODCODE>PW65</PRODCODE>
<GROUP>PW</GROUP>
<ALIAS>PW65</ALIAS>
</product>
<product>
<PRODCODE>PPW18</PRODCODE>
<GROUP>PPW</GROUP>
<ALIAS>PPW18</ALIAS>
</product>
<product>
<PRODCODE>PPW25</PRODCODE>
<GROUP>PPW</GROUP>
<ALIAS>PPW25</ALIAS>
</product>
</Product>
'
INSERT INTO COMBINATION_ACIL (fileds)
SELECT fileds.value('PRODCODE[1]', 'varchar(50)') AS prodcode,
fileds.value('GROUP[1]', 'varchar(50)') AS [group],
fileds.value('ALIAS[1]', 'varchar(50)') AS alias
FROM @COMBINATION_ACIL.nodes('Product/product') as COMBINATION_ACIL(fileds)
what is this error means?
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ')'. its error on the line of "insert into".
Did i write wrong syntax to import that xml into sql? what is the correct syntax?
thanks for your help :)