SQL Server 2016
I want to insert into a registered table using set processing using sde.next_rowid.
I do this in Oracle as:
INSERT INTO MYTABLE (OBJECTID, SITE_ID)
SELECT SDE.GDB_UTIL.NEXT(ROWID ('OWNER','MYTABLE'), SITE_ID FROM MYVIEW;
In SQL Server ESRI documentation examples I see selecting the objectid, writing down the number, and then hard coding it into the insert statement.
This will be a nightly job that will insert thousands of rows, so set processing is required.
INSERT INTO MYTABLE
SELECT SDE.NEXT_ROWID ('OWNER','MYTABLE'), SITE_ID
Cannot find either column "SDE" or the user-defined function or aggregate "SDE.NEXT_ROWID", or the name is ambiguous.
I can use SDE.NEXT_ROWID to query like so:
DECLARE @id as integer
EXEC sde.next_rowid 'OWNER', 'MYTABLE', @id OUTPUT;
SELECT @id "Next ObjectID";
and this works just fine.
I'm new to SQL Server, I'm sure it's a syntax issue.
Any insights are appreciated.