Jump to content

User:Sqltool/subpageboxtest

From Wikipedia, the free encyclopedia

This page is to test infobox with collapsable sidebar


FINANCIAL

XLeratorDB/Financial Documentation

ACCRINT Accrued Interest
ACCRINTM Accrued Interest at Maturity
COUPDAYS Coupon Days
COUPDAYSBS Coupon Days - beginning to settlement
COUPDAYSNC Coupon Days - settlement to next coupon
COUPNCD Coupon Days - next coupon date
COUPNUM Number of Coupon Days
COUPPCD Previous Coupon Date
CUMIPMT Cumulative Interest paid
CUMPRINC Cumulative Principal paid
DB Declining Balance
DDB Double Declining Balance
DISC Discount Rate
DOLLARDE Dollar - fraction to Decimal
DOLLARFR Dollar - decimal to Fraction
DURATION Annual Duration of a Security
EDATE Maturity
EFFECT Effective Annual Interest Rate
ENPV Enhanced Net Present Value
ENPV_q Enhanced Net Present Value
EOMONTH Last Day of Month
FV Future Value
FVSCHEDULE Future Value based on Compound Rates
INTRATE Interest Rate of a Security
IPMT Interest Payment based on Constant Rate
IRR Internal Rate of Return
IRR_q Internal Rate of Return
MDURATION Duration
MIRR Modified Internal Rate of Return
MIRR_q Modified Internal Rate of Return
NOMINAL Annual Nominal Interest Rate
NPER Number of Periods
NPV Net Present Value
NPV_q Net Present Value
ODDFPRICE Odd First Period Price
ODDFYIELD Odd First Period Yield
ODDLPRICE Odd Last Period Price
ODDLYIELD Odd Last Period Yield
PMT Payment of an Annuity
PPMT Principal Payment
PRICE Price of a Security
PRICEDISC Price of a Discounted Security
PRICEMAT Price at Maturity
PV Present Value
RATE Interest Rate for an Annuity
RECEIVED Amount Received at Maturity
SLN Straight Line Depreciation
SYD Sum-of-Year's-Digits Depreciation
TBILLEQ Bond Equivalent Yield for a Treasury Bill
TBILLPRICE Price for a Treasury Bill
TBILLYIELD Yield for a Treasury Bill
VDB Depreciation using Declining Balance
XIRR Internal Rate of Return with non-periodic cashflows
XIRR_q Internal Rate of Return with non-periodic cashflows
XNPV Net Present Value for non-periodic
XNPV_q Net Present Value for non-periodic cashflows
YEARFRAC Fraction of Year
YIELD Yield of a Security
YIELDDISC Yield of a Discounted Security
YIELDMAT Yield with Interest at Maturity

XLDB/FIN Release Version Information

STATISTICS

XLeratorDB/Statistics Documentation

XLDB/Stats Release/Version Information











http://en.wikipedia.org/wiki/File:WestClinTech_box_prod.jpg

XLeratorDB
Developer(s)Westclintech
Stable release
Operating systemMicrosoft SQL Server 2005 or later
TypeAnalytic Function Tool Set for DBMS
LicensePer server
Website[www.westclintech.com]

XLeratorDB uses Microsoft SQL CLR (Common Language Runtime) technology.[1] SQL CLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. SQL CLR relies on the creation, deployment and registration of .NET Framework assemblies that are physically stored in managed code dynamic-link libraries (DLL). The assemblies may contain .NET namespaces, classes, functions, and properties. Because managed code compiles to native code prior to execution, functions using SQL CLR can achieve significant performance increases versus the equivalent functions written in T-SQL in some scenarios.[2]

Technology

[edit]

XLeratorDB uses Microsoft SQL CLR (Common Language Runtime) technology.[3] SQL CLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. SQL CLR relies on the creation, deployment and registration of .NET Framework assemblies that are physically stored in managed code dynamic-link libraries (DLL). The assemblies may contain .NET namespaces, classes, functions, and properties. Because managed code compiles to native code prior to execution, functions using SQL CLR can achieve significant performance increases versus the equivalent functions written in T-SQL in some scenarios.[4]


XLeratorDB
FUNCTIONS
MATH
ENGINEERING

</

Technology

[edit]

XLeratorDB uses Microsoft SQL CLR (Common Language Runtime) technology.[5] SQL CLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. SQL CLR relies on the creation, deployment and registration of .NET Framework assemblies that are physically stored in managed code dynamic-link libraries (DLL). The assemblies may contain .NET namespaces, classes, functions, and properties. Because managed code compiles to native code prior to execution, functions using SQL CLR can achieve significant performance increases versus the equivalent functions written in T-SQL in some scenarios.[6]

XLeratorDB requires Microsoft SQL Server 2005 or SQL Server 2005 Express editions, or later.[7] The product installs with PERMISSION_SET=SAFE. SAFE mode, the most restrictive permission set, is accessible by all users. Code executed by an assembly with SAFE permissions cannot access external system resources such as files, the network, the internet, environment variables, or the registry.[8] >



Technology

[edit]

XLeratorDB uses Microsoft SQL CLR (Common Language Runtime) technology.[9] SQL CLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. SQL CLR relies on the creation, deployment and registration of .NET Framework assemblies that are physically stored in managed code dynamic-link libraries (DLL). The assemblies may contain .NET namespaces, classes, functions, and properties. Because managed code compiles to native code prior to execution, functions using SQL CLR can achieve significant performance increases versus the equivalent functions written in T-SQL in some scenarios.[10]

XLeratorDB requires Microsoft SQL Server 2005 or SQL Server 2005 Express editions, or later.[11] The product installs with PERMISSION_SET=SAFE. SAFE mode, the most restrictive permission set, is accessible by all users. Code executed by an assembly with SAFE permissions cannot access external system resources such as files, the network, the internet, environment variables, or the registry.[12]



{{ }}

XLeratorDB
FUNCTION PACKAGES
{{{Financial}}}
FINANCIAL
  • {{{XIRR npv yield}}}
STATISTICS
  • {{{list2}}}
{{{list3title}}}
  • {{{list3}}}
(......etc......)


Technology

[edit]

XLeratorDB uses Microsoft SQL CLR (Common Language Runtime) technology.[13] SQL CLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. SQL CLR relies on the creation, deployment and registration of .NET Framework assemblies that are physically stored in managed code dynamic-link libraries (DLL). The assemblies may contain .NET namespaces, classes, functions, and properties. Because managed code compiles to native code prior to execution, functions using SQL CLR can achieve significant performance increases versus the equivalent functions written in T-SQL in some scenarios.[14]

XLeratorDB requires Microsoft SQL Server 2005 or SQL Server 2005 Express editions, or later.[15] The product installs with PERMISSION_SET=SAFE. SAFE mode, the most restrictive permission set, is accessible by all users. Code executed by an assembly with SAFE permissions cannot access external system resources such as files, the network, the internet, environment variables, or the registry.[16]

  1. ^ http://westclintech.com/wct_local/Documentation/AboutXLeratorDB/tabid/148/topic/Technology/Default.aspx
  2. ^ This needs a reference
  3. ^ http://westclintech.com/wct_local/Documentation/AboutXLeratorDB/tabid/148/topic/Technology/Default.aspx
  4. ^ This needs a reference
  5. ^ http://westclintech.com/wct_local/Documentation/AboutXLeratorDB/tabid/148/topic/Technology/Default.aspx
  6. ^ This needs a reference
  7. ^ http://westclintech.com/Support/FAQ/tabid/143/Default.aspx#PL_A1_RequiredToInstall
  8. ^ Reference SQL Server DBMS documentation
  9. ^ http://westclintech.com/wct_local/Documentation/AboutXLeratorDB/tabid/148/topic/Technology/Default.aspx
  10. ^ This needs a reference
  11. ^ http://westclintech.com/Support/FAQ/tabid/143/Default.aspx#PL_A1_RequiredToInstall
  12. ^ Reference SQL Server DBMS documentation
  13. ^ http://westclintech.com/wct_local/Documentation/AboutXLeratorDB/tabid/148/topic/Technology/Default.aspx
  14. ^ This needs a reference
  15. ^ http://westclintech.com/Support/FAQ/tabid/143/Default.aspx#PL_A1_RequiredToInstall
  16. ^ Reference SQL Server DBMS documentation
Retrieved from "https://en.wikipedia.org/w/index.php?title=User:Sqltool/subpageboxtest&oldid=1254229489"