search

TablePlus / TablePlus-Windows

TablePlus Windows issue tracker
https://tableplus.com
185 stars 3 forks source link

[SQL Server] Syntax issue #358

Open huyphams opened 3 years ago

huyphams commented 3 years ago

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): SQL Server 2014

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 150

  3. The steps to reproduce this issue:

    • open storage procedure editor, change sth and then click ctrl+s
    • SQL preview will be: DROP PROCEDURE IF EXISTS [dbo].[xxxxxx]; which "IF EXISTS" is not supported in SQL Server 2014
    • error occurs:

image

IF EXISTS Applies to: SQL Server ( SQL Server 2016 (13.x) through current version). https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-procedure-transact-sql?view=sql-server-ver15

huyphams commented 3 years ago

Import from https://github.com/TablePlus/TablePlus/issues/2252