Sql report different database Respondida

Ramon Duunk

Can we make sql reports from a different database (running on the same server)
So for example :

USE TheNewDatabase
SELECT * FROM OCRD

 

Comentarios

3 comentarios

  • Comment author
    Caleb Das
    • Comentario oficial

    Sure you can. Just put the database name in front of OCRD. Something like:

    SELECT *

    FROM "OtherDatabaseName"."OCRD" T0

     

  • Comment author
    Ramon Duunk

    Hi,

    Sorry for not responding, had a lot to work on. (and now even more)
    It worked perfect, thnx !

    0
  • Comment author
    Ramon Duunk

    Did an update break this function ?

    0

Iniciar sesión para dejar un comentario.