Version Specific Snippets Script Blocks
I would like to be able to specify different script blocks inside a snippet that would work differently based upon the sql server version of the server I am connected to.
Or.... optionally have a version indicator on the snippet to perform the same thing. Then if two snippets share the same name it would apply the correct one based upon version.
EX:
:if $version_major$ >= 13
CREATE OR ALTER PROCEDURE [$dbo$].[$proc_name$] (@param1 INT) AS BEGIN
$CURSOR$SELECT @param1
END
GO
:else
IF OBJECT_ID('[$dbo$].[$proc_name$]', 'P') IS NULL BEGIN
EXEC('CREATE PROCEDURE [$dbo$].[$proc_name$] AS BEGIN SELECT 1; END;')
END
GO
ALTER PROCEDURE [$dbo$].[$proc_name$] (@param1 INT) AS BEGIN
$CURSOR$SELECT @param1
END
GO
:endif
1
vote
![](https://secure.gravatar.com/avatar/8a2c11ec4294a215021b196b79378c9c?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)