Posts by Lucas Cabral • 63 points
6 posts
-
1
votes0
answers32
viewsQ: Run ALTER on a PROCEDURE that is referenced by another object
I’m trying to change/drop the function [xxxx] according to the code. But the following error returns to me Msg 3729, Level 16, State 3, Procedure xxxxx, Line 1 [Batch Start Line 15] Cannot ALTER…
-
1
votes1
answer152
viewsQ: Connect MS SQL in PGADMIN
Hello, good afternoon! I need to know if there is any tool, script or anything else from where I can have the following scenario: I have a MS SQL database but need to manipulate it through pgAdmin…
-
1
votes1
answer711
viewsA: Connect to sql database a postgres database
Oops, I got this guide here... Thank you all for your attention. https://www.mssqltips.com/sqlservertip/3662/sql-server-and-postgresql-linked-server-configuration--part-2/…
-
1
votes1
answer711
viewsQ: Connect to sql database a postgres database
Scenario: I have the postgres database A, but I need to connect to the database from sql server 2017. How can I do this?
-
0
votes0
answers202
viewsQ: How to pass the variable on postgres using dbblink
Oops, good morning! I have the following query in postgres: declare $1 VARCHAR; BEGIN IF (SELECT COUNT(*) FROM tempo2 WHERE looping IS NULL) > 0 THEN $1 = (SELECT banco FROM tempo2 WHERE looping…
-
2
votes2
answers1455
viewsQ: Database/slow server
I’m starting in the database area and I notice a great slowness in some banks I use in virtual servers. In my case I access a windows that has a postgres and with an average frequency my scripts are…