| SQLFinancials. T-SQL ½ºÅ©¸³Æ® ¹× ÀúÀå ÇÁ·Î ½ÃÀú ¿ë SQL Server Financial Function ¶óÀ̺귯¸®¸¦ Á¦°øÇÕ´Ï´Ù. |
Áö±Ý ´Ù¿î·Îµå |
SQLFinancials. ¼øÀ§ ¹× ¿ä¾à
- °Ô½ÃÀÚ À̸§:
- By TotallySQL
- °Ô½ÃÀÚ À¥»çÀÌÆ®:
- http://www.totallysql.com
- ¿î¿µÃ¼Á¦:
- Windows 7, Windows 2003, Windows Vista, Windows XP, Windows Server 2008
SQLFinancials. ű×
SQLFinancials. ¼³¸í
SQLFinancials´Â MS Excel Analysis ToolPack¿¡ÀÖ´Â °Í°ú À¯»çÇÑ À繫 ºÐ¼® ±â´ÉÀ» Ãß°¡ÇÏ¿© T-SQL ½ºÅ©¸³Æà ȯ°æÀ» È®ÀåÇÏÁö¸¸ µ¥ÀÌÅͺ£À̽º ³»¿¡¼ Á÷Á¢ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. µ¥ÀÌÅͺ£À̽º ³»¿¡¼ µ¥ÀÌÅÍ ºÐ¼®À» ¼öÇàÇÏ´Â °ÍÀº ³×Æ®¿öÅ©¿¡¼ µ¥ÀÌÅ͸¦ Ŭ¶óÀ̾ðÆ® ÀÀ¿ë ÇÁ·Î±×·¥À¸·Î Àü¼ÛÇÏ´Â °Íº¸´Ù ÈξÀ ºü¸£°í È¿À²ÀûÀÌÁö ¾ÊÀ¸¸ç ´Ü¼øÇÏ°í Ŭ¸®³Ê ÀÀ¿ë ÇÁ·Î±×·¥À» ¸¸µì´Ï´Ù. Excel¿¡¼ µ¿µîÇÑ ¸ðµç ±ÝÀ¶ ±â´ÉÀº ¸Å¿ì ³ôÀº Á¤È®µµ¿¡ ¼ýÀÚ·Î Ãæ½ÇÇϹǷΠExcel ±â¹Ý ºñÁî´Ï½º ÀÛ¾÷À» µ¥ÀÌÅͺ£À̽º ȯ°æÀ¸·Î ½±°Ô ¸¶À̱׷¹ÀÌ¼Ç ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ÀÌ·¯ÇÑ ±â´É Áß ¸¹Àº ±â´ÉÀº ¿¢¼¿ »ó´ë¹æº¸´Ù ±¤¹üÀ§ÇÑ ¹üÀ§ÀÇ ÀÔ·Â °ªÀ» ÅëÇØ È¿°úÀûÀ̸ç Excel¿¡¼´Â ÀϺΠÃß°¡ ±â´ÉÀÌ ¾ø½À´Ï´Ù. »ç¿ë °¡´ÉÇÑ ÇÔ¼ö ¸ñ·Ï¿¡´Â ´ÙÀ½ÀÌ Æ÷ÇԵ˴ϴÙ. Accrint, Accrintm, Amordegr, amorlinc, coupdays, coupdayssbs, coupdaysnc, coupncd, coupnum, couppcd, cumpmt, cumprinc, daycount, daysinyear, db, ddb, disc, dollarde, dollerfr, Áö¼Ó ½Ã°£, È¿°ú, fv, fvschedule, intrate, ipmt, IRR, ISPMT, Mduration, MIRR, °øĪ, NPR, NPV, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PMT, PPMT, PRICE, PRICIEDISC, PRICEMAT, PV, RATE, RECECETEL, SLN, SYD, TBILLEQ, TBILLYIELD, VDB, XIRR, xnpv, yearfrac, ¼öÈ®·®, yipberdisc, ypowmat.
SQLFinancials. °ü·Ã ¼ÒÇÁÆ®¿þ¾î