Geek Answers Handbook

How to use user defined function in SQL which from another db

I have a user-defined function in a different database than the one with which I request. Is there a way to access a function like full name or something similar in SQL? I'm trying to do it

[dbo].[EscalationManagementSystem].fncCVUnix2DateTZ(...

But I get a message that he cannot find the dbo column or the user-defined function dbo.EscalationManagemntSystem.fncCVUnix2DateTZ. Is my syntax wrong?

+5
source share
2 answers

The correct format is Database.Schema.Object, so you will have:

[EscalationManagementSystem].[dbo].[fncCVUnix2DateTZ](...

+8
source

, db, -, " ", :

SERVER.DATABASE.SCHEMA.OBJECT

+1

More articles:


All Articles