Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling a SQL Server UDF
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00951187
Message ID:
00951188
Vues:
10
This message has been marked as the solution to the initial question of the thread.
You can call it w/o DB name
SELECT DBO.FN_DIASACALCULAR (@FechaIni,@FechaFin) As DiasACalcular
>Hi All, I have the following code to call a SQL Server UDF.
>
>
>Declare @FechaIni Datetime
>Declare @FechaFin Datetime
>
>Set @FechaIni='20040830'
>Set @FechaFin='20041030'
>
>SELECT DATA001.DBO.FN_DIASACALCULAR (@FechaIni,@FechaFin) As DiasACalcular
>
>
>So far so good. But what if I want to make this sintax non database dependent, I mean, I'm planning to use this same function on several databases and I don't want to change the UDF's prefix on each one.
>
>It's there a way to call the UDF without the "DATA001.DBO" prefix. I've tried changing the UDF access to public but it didn't work.
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform