There are two ways to prevent your SQL code from running on a testing or production server. You can use the @@SERVERNAME Variable or the DB_NAME function, as shown next below:
@@SERVERNAMEIF @@SERVERNAME = 'ProductionServerName'BEGINPRINT 'Code will NOT execute'RETURNENDELSEBEGINPRINT 'Code will execute'ENDDB_NAME()IF DB_NAME() = 'ProductionServerName'BEGINPRINT 'Code will NOT execute'RETURNENDELSEBEGINPRINT 'Code will execute'END
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
