how to change version of sql that scripts are created for
Posted: Wed 19 Jun 2019 14:51
how do you change the version of sql that scripts are generated for?
In ssms you could specify the version of sql to script for.
For instance, this script:
DROP VIEW IF EXISTS dbo.myview
doesn't run in sql 2014, only 17.
a lot of our clients are still on 14 and it would fail. I need an option to make the scripts generated work in 14 (or 12 or 8 etc)
Thanks
In ssms you could specify the version of sql to script for.
For instance, this script:
DROP VIEW IF EXISTS dbo.myview
doesn't run in sql 2014, only 17.
a lot of our clients are still on 14 and it would fail. I need an option to make the scripts generated work in 14 (or 12 or 8 etc)
Thanks