Made step 3: added one more parameter to SP: IF object_id('dbo.addVehicleRegister1', 'p') IS NULLĮxec ('CREATE PROCEDURE dbo. If you create a table, you get the window mentioned above where you define all the table components from the UI: an appropriate DDL statement will be generated. with the Generate action, a DDL snippet will be pasted in the editor. Run it and: SP source changed correctly, but parameters list in database tree and hints are remains the same - bit parameter on last place. If you create a function, procedure, trigger etc. I changed parameter order: IF object_id('dbo.addVehicleRegister1', 'p') IS NULL So I've created copy of this SP: IF object_id('dbo.addVehicleRegister1', 'p') IS NULLĮxec ('CREATE PROCEDURE dbo.addVehicleRegister1 AS SELECT 1')Īnd when I run it first time, it was created correctly: ![]() My actual code of creating and altering SP: IF object_id('dbo.addVehicleRegister', 'p') IS NULLĮxec ('CREATE PROCEDURE dbo.addVehicleRegister AS SELECT 1') Since i will start working away from home on my MAC i. There is a request on our tracker for MySQL debugger, please follow and vote. I have previously created allot of stored procedures on the server with the help of Microsoft SQL Server Data Tool. At the moment we have only Oracle PL/SQL debugger. I'm working on a projekt with a MS SQL V12 server running in Azure. Hi there i just started using DataGrip as my SQL IDE on MAC. Is it settings or DataGrip issue? How to fix it? Access MS SQL stored procedures serverside. This happens with different projects, different databases (but they are the same 2008R2). In the "Preferences"->"Hints" there is nothing interesting to set. When I right-click on this query the "Hints settings." do nothing! It didn't open any settings. If I try to get the source of SP from this tree it shows correct code - the same as I have in my source file. In database tree it shows (bit parameter must be the last): when parameter list is: param1, param2, param3 it shows "param1, param3, param2". The problem is that DataGrip shows wrong parameter list sequence when calling stored procedure. I have latest DataGrip 2020.1 for MacOs (the same issue was with 2019.3.3, 2019.3.4), MS SQL Server 2008 R2, driver version is 8.2.2 (the same issue was with 7th driver version).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |