Not sure what your problem is. I was able to run your code, with two modificiations. The column should be c1, and since the name is an attribute that should be @name.

But I don't know what sort of result you are looking for.

This is what I ran:

DECLARE @xml XML =

( SELECT * FROM OPENROWSET(BULK 'C:\temp\test.xml', SINGLE_BLOB) AS data)

SELECT @xml c1 INTO ttt

select c1 FROM ttt

SELECT

c1.value('(testsuite/testcase/@name)[1]', 'nvarchar(max)') as name

,c1.value('(testsuite/testcase/summary)[1]', 'nvarchar(max)') as summary

FROM ttt

go

DROP TABLE ttt