Comments by khan baba20 (Top 2 by date)

khan baba20 6-Sep-22 6:54am View

I have used below code, it gives me null result, can any one help me how can i write TSQL query to insert data into SQL Table from XML file, If anyone can help me really appreciated,

khan baba20 3-Sep-22 10:37am View

DECLARE @cars xml

SELECT @cars = C
FROM OPENROWSET (BULK 'C:\Users\Ali\Downloads\Alps SQL Skills Test (2) (1)\Alps SQL Skills Test\Alps SQL Skills Test\GradeSets.xml', SINGLE_BLOB) AS Cars(C)

SELECT @cars

DECLARE @hdoc int

EXEC sp_xml_preparedocument @hdoc OUTPUT, @cars
SELECT *
FROM OPENXML (@hdoc, 'GradeSets/GradeSet/GradeGroup' ,2)
WITH(
Grade Varchar(20),
points INT,
Success VARCHAR(100)
)
it gives me Null in points and success column,