title: Alias name in Delete/Update : Incorrect syntax near the keyword 'AS
body: <p>How i can use alias name in delete/update statement.
  Please see my SP below. it gives error Incorrect syntax near the keyword 'AS</p>
  
  <pre><code>/****** Object:  StoredProcedure [dbo].[usp_Market_Delete]    Script Date: 05/22/2015 16:37:04 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE PROCEDURE [dbo].[usp_Market_Delete]
  (
      @Original_MarketCd char(3)
  )
  AS
      SET NOCOUNT OFF;
  DELETE FROM [MKT]  WHERE (([MKT_CD] AS MarketCd = @Original_MarketCd))
  GO
  </code></pre>