SQLize Online / PHPize Online  /  SQLtest Online

begin declare @XMLAdditionalInitialScreening xml set @XMLAdditionalInitialScreening = cast (N'<Table1> <c1>3</c1> <c2>0</c2> <c3>15/01/2024</c3> <c4>A</c4> <c5>AA</c5> <c6>AVCSAA</c6> </Table1>' as xml ) CREATE TABLE #tblIMMSCREENINGTest ( Screeningdate datetime, ScreeningTest VARCHAR(100), RESULT VARCHAR(100), Remarks VARCHAR(100) ) INSERT INTO #tblIMMSCREENINGTest ( Screeningdate ,ScreeningTest ,RESULT ,Remarks ) SELECT convert(datetime, data.value('c3[1]', 'varchar(100)'), 103), data.value('c1[1]', 'varchar(100)'), data.value('c2[1]', 'varchar(100)'), data.value('c4[1]', 'varchar(100)') FROM @XMLAdditionalInitialScreening.nodes('/Table1') as ParamValues (data) END