SQL Server – What Does a ‘/’ Mean After a SQL Statement?

sql serversql-server-2008-r2t-sql

I have a script that we are using to update our ERP database to a new version,

UPDATE ENUM_CODES SET COLUMN_NAME = 'PAY_STATUS' WHERE TABLE_NAME = 'PAYABLE' and COLUMN_NAME = 'STATUS'
/

but i dont know why it has the / after the update portion.
Does anyone know what that / means?

Best Answer

/ is the Oracle equivalent of SQL Server's GO...

It would seem that your ERP supports multiple RDBMS platforms, and you're looking at a script originally written for an Oracle database.

As it is currently written, you'll probably get a compilation error on SQL Server. Trade that / for a GO and you'll be in business (assuming the rest of the script is correct, of course).

Related Question