how to split the xml and store the value into a column

declare @T table
(
  Records xml
)
declare @c_xml_data varchar(1000)

set @c_xml_data = (select c_xml from bc_xml_errors where n_id=453048)

insert into @T values(@c_xml_data)
select
       V.X.value('@acw_id', 'nvarchar(10)') as c_acw_id
from @T as T
 cross apply T.Records.nodes('updateapproval/request/approver/stdid') as V(X)