|
if exists (select *
from dbo.sysobjects
where id = object_id(N'[dbo].[f_Get_CurrencyCd]')
and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[f_Get_CurrencyCd]
go
/*
Returns current currency from the current context.
*/
create function dbo.f_Get_CurrencyCd()
returns nchar(3)
as
begin
declare @CurrencyCd nchar(3)
set @CurrencyCd = dbo.f_Get_Str_From_CONTEXT_INFO('C')
return @CurrencyCd
end
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.