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.
SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
CREATE PROCEDURE [=updateCAD]
EXECUTE AS CALLER
select FPARTNO ,FCCADFILE1
where FPARTNO = 'TEST1234'
update INMAST set FCCADFILE1='1234ABCD.PDF' where FPARTNO = 'TEST1234'