存储过程-将参数作为xml传递并读取数据

我只需要一个

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)