Saving Infiniti Answer Files

The Infiniti answer file can be passed as a input parameter value. Usually destined for an XML or NVARCHAR(MAX) column type.

To do so use the following reference for the Parameter's input value.

[intelledoxanswerfile]

See the screen shots and SQL queries below for examples.

CREATE TABLE [dbo].[Submission](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[AnswerFile] [xml] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

CREATE PROCEDURE sp_SaveAnswerFileToArchive
	@AnswerFile XML
AS
	INSERT INTO Submission (AnswerFile) VALUES (@AnswerFile)
	SELECT @@IDENTITY AS Id
GO