Hello,
I am trying to create an update query that will grab a parameter, do an insert, and then return the autoincrement ID. I realize that this will throw a syntax error, but this should give you an idea of what I am after:
PARAMETERS stNewTitle Text ( 50 );
SET NOCOUNT ON;
INSERT INTO tblJobType ( strJobDescription ) VALUES (stNewTitle);
SELECT @@Identity AS intID;
Can anyone help?
Thank you very much,
FtB
Start Free Trial
