我只需要一个WHERE
子句。
INSERT INTO SN_IO ( [C1] ,[C2] ,[C3] )
SELECT [C1] ,[C2] ,[C3]
FROM OPENXML (@currRecord, 'ios/io', 1)
WITH ([C1] [varchar](25) 'C1',
[C2] [varchar](25) 'C2',
[C3] [varchar](20) 'C3' )
WHERE [C1] IS NOT NULL AND [C2] IS NOT NULL AND [C3] IS NOT NULL
或者,您也可以在XPath中做到这一点,我想它可能会更有效
FROM OPENXML (@currRecord, 'ios/io[C1 and C2 and C3]', 1)