Problem Passing XML Parameter to SQL Server Stored Procedure

Question

I am trying to create a stored procedure that accepts XML data as an input parameter, but cannot compile it. Code:

CREATE PROCEDURE dbo.idn_UpdateUserApplications ( @AppIdList xml, @UserID nvarchar(256), @ModifiedBy nvarchar(256) ) AS BEGIN SET NOCOUNT ON INSERT INTO userapplication (userid, modifiedby, modifiedon, appid) SELECT @UserID as userid, @ModifiedBy As modifiedby, Getdate() as modifiedon, paramvalues.id.VALUE('.', 'VARCHAR(20)') AS appid FROM @AppIdList.NODES('/Applications/id') AS paramvalues(ID) END 

Error: Msg 317, level 16, state 1, procedure idn_UpdateUserApplications, line 13 The table function "NODES" cannot have a column alias.

Answer 1

NODES and VALUE must be lowercase NODES , VALUE .