Hope this is the right place to post.
I have this simple stored procedure I'm testing but it isn't updating the DB.
It's pretty straightforward, looking for help as to what I'm doing wrong.
Thanks
USE [DATA10];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE PROCEDURE [=updateCAD]
WITH
EXECUTE AS CALLER
AS
select FPARTNO ,FCCADFILE1
from INMAST
where FPARTNO = 'TEST1234'
begin
update INMAST set FCCADFILE1='1234ABCD.PDF' where FPARTNO = 'TEST1234'
end.