|
if exists (select *
from dbo.sysobjects
where id = object_id(N'[dbo].[f_Get_Currency]')
and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[f_Get_Currency]
go
CREATE FUNCTION dbo.f_Get_Currency
(
)
RETURNS Table as return
select c.Code as CurrencyCode,
c.PrintSign as CurrencySign,
c.Rate as CurrencyRate
from Currencies c with (nolock)
where c.Code = dbo.f_Get_CurrencyCd_Mesh();
go
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.