Msg 511, Level 16, State 1 Error: Cannot create a row of size 15155 which is greater than the allowable maximum row size of 8060

Question

Dear All,

I need to read an xml & insert the attribute value to a table in sqlserver.

I have 268 attribue values in xml & with same number of columns in table.

INSERT INTO ParticipantMaster_7(CurrentRoleID,ClientID,CreatedDateTime,ModifiedDateTime, & so on)
SELECT 65,7,GETDATE(),GETDATE(),@UserID,@UserID,0,*
FROM OPENXML (@XmlDocumentHandle, '/Root/Record',2)WITH ([ChildRegistrationNumber] NVARCHAR(MAX) '@ChildRegistrationNumber',[FirstName] NVARCHAR(MAX) '@FirstName',[MiddleName] NVARCHAR(MAX) '@MiddleName',[LastName] NVARCHAR(MAX) '@LastName',[Gender] NVARCHAR(MAX) '@Gender',[Gender_1] NVARCHAR(MAX) '@Gender_1', & so on)

Please help me to resolve this issue.

Regards

Madhusudhan

Answer 1

Try using the proper datatypes instead of NVARCHAR(MAX) for everything.

For example - is NVARCHAR(MAX) appropriate for @Gender?  Maybe NCHAR(1) is more appropriate and so on.