Example displaying when data is sent in form of xml document CREATE PROCEDURE XMLINSERT @intShowVersion INT =0, @strClassName varchar(250), @strLang varchar(10), @strXml text='', @intError int output AS SET NOCOUNT ON /* @intShowVersion INTEGER =0, @strCreatedBy VARCHAR(20) = '' , @intTemplateID INTEGER = 0, @dtClientCreatedOn DATETIME = '' , @strUpdatedBy VARCHAR(20) = '' , @dtClientUpdatedOn DATETIME = '' , @strXml text='', SET DATEFORMAT dmy IF (@intShowVersion = 1 ) BEGIN SELECT VERSION='$Revision: ......