Update Procedure

• Phoenix-260778

  SSC Journeyman

  Points: 79

  More actions

  September 21, 2007 at 10:04 am

  #178487

  This might sound like a stupid question. I have recently switched from sql 2000 to sql 2005. I am attempting to execute an update query. when I execute the code a message displays that the command executed succesfully. However the field values doesn't update. It worked in sql2000. what am I doing wrong.

  The code is as follows:

  USE

  [TEST]

  GO

   

  SET

  ANSI_NULLS ON

  GO

  SET

  QUOTED_IDENTIFIER ON

  GO

  ALTER

  PROCEDURE [dbo].[usp_update1]

   

  As

  UPDATE

  ftest.dbo.TBL1

  SET

  TBL1 = 'b1'

   

  WHERE

   field1 = 'b1'

   

  Thanks in advance for your your help.

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  September 21, 2007 at 10:34 am

  #735312

  This may sound like a stupid question but are you executing the procedure or executing the code you listed there to alter the procedure?