Thanks in advance Gail..

Where should I move this 'AS'?

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:<Kalpana Dhungel>

-- Create date: <Nov 08 2010>

-- Description:<enter records in required fields>

-- =============================================

CREATE PROCEDURE [dbo].[createAlter]

@ID...

Thank you so much Gail

Still I am getting this

Msg 156, Level 15, State 1, Procedure createAlter, Line 31

Incorrect syntax near the keyword 'AS'.

Msg 102, Level 15, State 1, Procedure createAlter,...