Home Forums Article Discussions Article Discussions by Author Discuss content posted by Diego Buendía Parsing Parameters in a Stored Procedure RE: Parsing Parameters in a Stored Procedure

  • August 10, 2010 at 12:44 am

    #1204510

    The XML Version

    declare @Param as xml

    set @Param = '<I>1</I><I>2</I><I>3</I>'

    select IntList.IntField.value('.', 'int')

    from @Param.nodes('I') IntList(IntField)