Hi all, help is needed!
I'm running this query:
"INSERT INTO location (x,y) OUTPUT INSERTED.Location_ID VALUES ("+x+","+y+")"
which works fine on my SQL EXPRESS 2005 (i get the id back, which is a must).
However, my server has SQL 2000, and when i try to run the query i get an exception:
" Line 1: Incorrect syntax near 'OUTPUT' "
Anyone knows a workaround
How can you run such a query on 2000