{"id":1732,"date":"2026-09-24T09:00:00","date_gmt":"2026-09-24T09:00:00","guid":{"rendered":"https:\/\/otus.ru\/journal\/?p=1732"},"modified":"2026-09-24T09:30:18","modified_gmt":"2026-09-24T09:30:18","slug":"osobennosti-formirovaniya-i-ispolzovaniya-ms-sql-funkcij","status":"publish","type":"post","link":"https:\/\/otus.ru\/journal\/osobennosti-formirovaniya-i-ispolzovaniya-ms-sql-funkcij\/","title":{"rendered":"\u041f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u0441\u043a\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0432 MS SQL Server: \u0441\u043a\u0430\u043b\u044f\u0440\u043d\u044b\u0435, \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u044b\u0435 \u0438 \u043e\u0442\u043b\u0438\u0447\u0438\u044f \u043e\u0442 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440"},"content":{"rendered":"

\u041f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u0441\u043a\u0430\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f (UDF, user-defined function)<\/strong> \u0432 MS SQL Server — \u044d\u0442\u043e \u043e\u0431\u044a\u0435\u043a\u0442 \u0431\u0430\u0437\u044b, \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u044b\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439 CREATE FUNCTION<\/code>, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u0435\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u0438 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043b\u0438\u0431\u043e \u043e\u0434\u043d\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 (\u0441\u043a\u0430\u043b\u044f\u0440\u043d\u0430\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f), \u043b\u0438\u0431\u043e \u043d\u0430\u0431\u043e\u0440 \u0441\u0442\u0440\u043e\u043a (\u0442\u0430\u0431\u043b\u0438\u0447\u043d\u0430\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f). \u0424\u0443\u043d\u043a\u0446\u0438\u044e \u0432\u044b\u0437\u044b\u0432\u0430\u044e\u0442 \u0432\u043d\u0443\u0442\u0440\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 — \u0432 SELECT<\/code>, WHERE<\/code>, JOIN<\/code>, APPLY<\/code>, — \u0438 \u0432 \u044d\u0442\u043e\u043c \u0435\u0435 \u0433\u043b\u0430\u0432\u043d\u043e\u0435 \u043e\u0442\u043b\u0438\u0447\u0438\u0435 \u043e\u0442 \u0445\u0440\u0430\u043d\u0438\u043c\u043e\u0439 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b, \u043a\u043e\u0442\u043e\u0440\u0443\u044e \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u044e\u0442 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439 EXEC<\/code>.<\/p>\n

\n

\u0421\u043e\u0434\u0435\u0440\u0436\u0430\u043d\u0438\u0435<\/strong><\/p>\n

    \n
  1. \u0421\u043b\u043e\u0432\u0430\u0440\u044c: \u0447\u0442\u043e \u0441 \u0447\u0435\u043c \u043d\u0435 \u043f\u0443\u0442\u0430\u0442\u044c<\/a><\/li>\n
  2. \u041f\u0435\u0440\u0435\u0434 \u0437\u0430\u043f\u0443\u0441\u043a\u043e\u043c: \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u044f \u0431\u0430\u0437\u0430 \u0438 \u043f\u0440\u0430\u0432\u0430<\/a><\/li>\n
  3. \u041c\u0438\u043d\u0438\u043c\u0430\u043b\u044c\u043d\u044b\u0439 \u043f\u043e\u043b\u043d\u044b\u0439 \u043f\u0440\u0438\u043c\u0435\u0440: \u0442\u0440\u0438 \u0432\u0438\u0434\u0430 \u0444\u0443\u043d\u043a\u0446\u0438\u0439<\/a><\/li>\n
  4. \u041a\u0430\u043a \u0432\u044b\u0437\u044b\u0432\u0430\u0442\u044c: \u0441\u0445\u0435\u043c\u0430, DEFAULT \u0438 APPLY<\/a><\/li>\n
  5. \u0427\u0435\u043c \u0444\u0443\u043d\u043a\u0446\u0438\u044f \u043e\u0442\u043b\u0438\u0447\u0430\u0435\u0442\u0441\u044f \u043e\u0442 \u0445\u0440\u0430\u043d\u0438\u043c\u043e\u0439 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b<\/a><\/li>\n
  6. SCHEMABINDING \u0438 \u0434\u0435\u0442\u0435\u0440\u043c\u0438\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0441\u0442\u044c<\/a><\/li>\n
  7. \u041f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c: \u0433\u0434\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0442\u043e\u0440\u043c\u043e\u0437\u044f\u0442<\/a><\/li>\n
  8. \u041f\u0440\u0430\u0432\u0430 \u043d\u0430 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0438 \u0432\u044b\u0437\u043e\u0432<\/a><\/li>\n
  9. \u0415\u0441\u043b\u0438 \u043d\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u043e\u0441\u044c<\/a><\/li>\n
  10. \u0412\u044b\u0432\u043e\u0434\u044b<\/a><\/li>\n
  11. \u0413\u0434\u0435 \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u0435\u0442\u0441\u044f \/ \u0441\u0432\u044f\u0437\u044c \u0441 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u043e\u0439<\/a><\/li>\n
  12. FAQ<\/a><\/li>\n<\/ol>\n<\/div>\n

    \u041a\u043e\u0440\u043e\u0442\u043a\u043e \u043e \u0442\u0440\u0435\u0445 \u0432\u0438\u0434\u0430\u0445: \u0441\u043a\u0430\u043b\u044f\u0440\u043d\u0430\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043e\u0434\u043d\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0438 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f \u0432 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0438, \u0432\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u0430\u044f \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u0430\u044f (inline TVF) — \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u043e\u0434\u043d\u043e\u0433\u043e SELECT<\/code>, \u043c\u043d\u043e\u0433\u043e\u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043d\u0430\u044f \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u0430\u044f (MSTVF) — \u0442\u0430\u0431\u043b\u0438\u0446\u0443, \u043a\u043e\u0442\u043e\u0440\u0443\u044e \u0437\u0430\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u043a\u043e\u0434 \u0438\u0437 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0439.<\/p>\n

    \u041d\u0438\u0436\u0435 — \u0442\u0440\u0438 \u0432\u0438\u0434\u0430 UDF \u043d\u0430 \u043e\u0434\u043d\u043e\u043c \u0441\u043a\u0432\u043e\u0437\u043d\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435, \u0442\u0438\u043f\u0438\u0447\u043d\u044b\u0435 \u043e\u0448\u0438\u0431\u043a\u0438 \u0441 \u0440\u0435\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0442\u0435\u043a\u0441\u0442\u0430\u043c\u0438 \u0441\u0435\u0440\u0432\u0435\u0440\u0430, \u043f\u0440\u0430\u0432\u0430, SCHEMABINDING<\/code> \u0438 \u0442\u043e, \u043a\u0430\u043a \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0432\u043b\u0438\u044f\u044e\u0442 \u043d\u0430 \u0441\u043a\u043e\u0440\u043e\u0441\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432. \u041f\u0440\u0438\u043c\u0435\u0440\u044b \u043f\u0440\u043e\u0432\u0435\u0440\u0435\u043d\u044b 23.09.2026 \u043d\u0430 \u0434\u0432\u0438\u0436\u043a\u0435 Azure SQL Edge 15.0 (\u044f\u0434\u0440\u043e \u043b\u0438\u043d\u0435\u0439\u043a\u0438 SQL Server 2019, \u0443\u0440\u043e\u0432\u0435\u043d\u044c \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u0438 150).<\/p>\n

    \u0421\u043b\u043e\u0432\u0430\u0440\u044c: \u0447\u0442\u043e \u0441 \u0447\u0435\u043c \u043d\u0435 \u043f\u0443\u0442\u0430\u0442\u044c<\/h2>\n\n\n\n\n\n\n\n\n\n
    \u0422\u0435\u0440\u043c\u0438\u043d<\/th>\n\u0427\u0442\u043e \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442<\/th>\n\u0413\u0434\u0435 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f<\/th>\n<\/tr>\n<\/thead>\n
    \u0412\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u0430\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f (LEN<\/code>, ROUND<\/code>, SUM<\/code>)<\/td>\n\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435<\/td>\n\u0432 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/td>\n<\/tr>\n
    \u0421\u043a\u0430\u043b\u044f\u0440\u043d\u0430\u044f UDF<\/td>\n\u043e\u0434\u043d\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435<\/td>\n\u0432 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f\u0445, \u0432\u0441\u0435\u0433\u0434\u0430 \u0441 \u0438\u043c\u0435\u043d\u0435\u043c \u0441\u0445\u0435\u043c\u044b: dbo.fn(...)<\/code><\/td>\n<\/tr>\n
    \u0412\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u0430\u044f \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u0430\u044f (inline TVF)<\/td>\n\u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u043e\u0434\u043d\u043e\u0433\u043e SELECT<\/code><\/td>\n\u0432\u043e FROM<\/code>, JOIN<\/code>, APPLY<\/code><\/td>\n<\/tr>\n
    \u041c\u043d\u043e\u0433\u043e\u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043d\u0430\u044f \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u0430\u044f (MSTVF)<\/td>\n\u0442\u0430\u0431\u043b\u0438\u0446\u0443-\u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0443\u044e, \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u043d\u0443\u044e \u043a\u043e\u0434\u043e\u043c<\/td>\n\u0432\u043e FROM<\/code>, JOIN<\/code>, APPLY<\/code><\/td>\n<\/tr>\n
    \u0425\u0440\u0430\u043d\u0438\u043c\u0430\u044f \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0430<\/td>\n\u043d\u0430\u0431\u043e\u0440\u044b \u0441\u0442\u0440\u043e\u043a, \u043a\u043e\u0434 \u0432\u043e\u0437\u0432\u0440\u0430\u0442\u0430, OUTPUT-\u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b<\/td>\n\u0442\u043e\u043b\u044c\u043a\u043e \u0447\u0435\u0440\u0435\u0437 EXEC<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u0412\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 (\u0441\u0442\u0440\u043e\u043a\u043e\u0432\u044b\u0435, \u0434\u0430\u0442\u044b, \u043c\u0430\u0442\u0435\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0435, \u0430\u0433\u0440\u0435\u0433\u0430\u0442\u043d\u044b\u0435, \u043e\u043a\u043e\u043d\u043d\u044b\u0435 \u0441 OVER<\/code>) \u0434\u0430\u0435\u0442 \u0441\u0430\u043c \u0441\u0435\u0440\u0432\u0435\u0440, \u0438\u0445 \u043d\u0435 \u0441\u043e\u0437\u0434\u0430\u044e\u0442. \u042d\u0442\u0430 \u0441\u0442\u0430\u0442\u044c\u044f — \u043f\u0440\u043e \u0444\u0443\u043d\u043a\u0446\u0438\u0438, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u0438\u0448\u0435\u0442\u0435 \u0432\u044b.<\/p>\n

    \u041f\u0435\u0440\u0435\u0434 \u0437\u0430\u043f\u0443\u0441\u043a\u043e\u043c: \u0442\u0435\u0441\u0442\u043e\u0432\u0430\u044f \u0431\u0430\u0437\u0430 \u0438 \u043f\u0440\u0430\u0432\u0430<\/h2>\n

    \u0412\u0441\u0435 \u043f\u0440\u0438\u043c\u0435\u0440\u044b \u043c\u0435\u043d\u044f\u044e\u0442 \u0441\u0445\u0435\u043c\u0443 dbo<\/code> (\u0441\u043e\u0437\u0434\u0430\u044e\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u0443, \u0444\u0443\u043d\u043a\u0446\u0438\u0438, \u0441\u0442\u043e\u043b\u0431\u0446\u044b), \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0439\u0442\u0435 \u0438\u0445 \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0439 \u0442\u0435\u0441\u0442\u043e\u0432\u043e\u0439 \u0431\u0430\u0437\u0435, \u0430 \u043d\u0435 \u0432 \u0440\u0430\u0431\u043e\u0447\u0435\u0439. \u0420\u043e\u043b\u044c sysadmin<\/code> \u0438\u043b\u0438 db_owner<\/code> \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u043d\u0435 \u043d\u0443\u0436\u043d\u0430: \u0441\u043e\u0437\u0434\u0430\u0442\u0435\u043b\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u043f\u0440\u0430\u0432\u0430 CREATE FUNCTION<\/code> \u0432 \u0431\u0430\u0437\u0435 \u0438 ALTER<\/code> \u043d\u0430 \u0441\u0445\u0435\u043c\u0443, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0441\u043e\u0437\u0434\u0430\u0435\u0442\u0441\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f, \u0430 \u0434\u043b\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0438\u0437 \u043f\u0440\u0438\u043c\u0435\u0440\u0430 — \u0435\u0449\u0435 CREATE TABLE<\/code>. \u0411\u0435\u0437 ALTER<\/code> \u043d\u0430 \u0441\u0445\u0435\u043c\u0443 \u043f\u0435\u0440\u0432\u044b\u0439 \u0436\u0435 CREATE FUNCTION<\/code> \u0443\u043f\u0430\u0434\u0435\u0442 \u0441 \u043e\u0448\u0438\u0431\u043a\u043e\u0439 2760. \u041f\u043e\u0434\u0440\u043e\u0431\u043d\u043e\u0441\u0442\u0438 \u0438 \u0433\u0440\u0430\u043d\u0438\u0446\u044b \u044d\u0442\u0438\u0445 \u043f\u0440\u0430\u0432 — \u0432 \u0440\u0430\u0437\u0434\u0435\u043b\u0435 \u00ab\u041f\u0440\u0430\u0432\u0430 \u043d\u0430 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0438 \u0432\u044b\u0437\u043e\u0432\u00bb \u043d\u0438\u0436\u0435.<\/p>\n

    \u041c\u0438\u043d\u0438\u043c\u0430\u043b\u044c\u043d\u044b\u0439 \u043f\u043e\u043b\u043d\u044b\u0439 \u043f\u0440\u0438\u043c\u0435\u0440: \u0442\u0440\u0438 \u0432\u0438\u0434\u0430 \u0444\u0443\u043d\u043a\u0446\u0438\u0439<\/h2>\n

    \u0421\u043a\u0440\u0438\u043f\u0442 \u0441\u043e\u0437\u0434\u0430\u0435\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0437\u0430\u043a\u0430\u0437\u043e\u0432 \u0438 \u043f\u043e \u043e\u0434\u043d\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u0432\u0438\u0434\u0430.<\/p>\n

    CREATE<\/span> <\/span>TABLE<\/span> <\/span>dbo<\/span>.<\/span>Orders<\/span> (<\/span>\n    <\/span>OrderId<\/span>    <\/span>int<\/span> <\/span>IDENTITY<\/span> <\/span>PRIMARY<\/span> <\/span>KEY<\/span>,<\/span>\n    <\/span>Customer<\/span>   <\/span>nvarchar<\/span>(<\/span>50<\/span>)  <\/span>NOT<\/span> <\/span>NULL<\/span>,<\/span>\n    <\/span>Amount<\/span>     <\/span>decimal<\/span>(<\/span>10<\/span>,<\/span>2<\/span>) <\/span>NOT<\/span> <\/span>NULL<\/span>,<\/span>\n    <\/span>OrderDate<\/span>  <\/span>date<\/span>          <\/span>NOT<\/span> <\/span>NULL<\/span>\n);<\/span>\nINSERT<\/span> <\/span>INTO<\/span> <\/span>dbo<\/span>.<\/span>Orders<\/span> (<\/span>Customer<\/span>, <\/span>Amount<\/span>, <\/span>OrderDate<\/span>) <\/span>VALUES<\/span>\n (<\/span>N<\/span>'\u0410\u043d\u043d\u0430'<\/span>, <\/span>1200<\/span>.<\/span>00<\/span>, <\/span>'2026-09-01'<\/span>),<\/span>\n (<\/span>N<\/span>'\u0410\u043d\u043d\u0430'<\/span>,  <\/span>300<\/span>.<\/span>00<\/span>, <\/span>'2026-09-15'<\/span>),<\/span>\n (<\/span>N<\/span>'\u0411\u043e\u0440\u0438\u0441'<\/span>, <\/span>5000<\/span>.<\/span>00<\/span>, <\/span>'2026-09-10'<\/span>);<\/span>\nGO<\/span>\n-- 1. \u0421\u043a\u0430\u043b\u044f\u0440\u043d\u0430\u044f: \u043e\u0434\u043d\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043d\u0430 \u0432\u044b\u0437\u043e\u0432<\/span>\nCREATE<\/span> <\/span>OR<\/span> <\/span>ALTER<\/span> <\/span>FUNCTION<\/span> <\/span>dbo<\/span>.<\/span>fn_WithVat<\/span> (<\/span>@<\/span>amount<\/span> <\/span>decimal<\/span>(<\/span>10<\/span>,<\/span>2<\/span>), <\/span>@<\/span>rate<\/span> <\/span>decimal<\/span>(<\/span>4<\/span>,<\/span>2<\/span>) <\/span>=<\/span> <\/span>0<\/span>.<\/span>20<\/span>)<\/span>\nRETURNS<\/span> <\/span>decimal<\/span>(<\/span>12<\/span>,<\/span>2<\/span>)<\/span>\nAS<\/span>\nBEGIN<\/span>\n    <\/span>RETURN<\/span> <\/span>ROUND<\/span>(<\/span>@<\/span>amount<\/span> <\/span>*<\/span> (<\/span>1<\/span> <\/span>+<\/span> <\/span>@<\/span>rate<\/span>), <\/span>2<\/span>);<\/span>\nEND<\/span>;<\/span>\nGO<\/span>\n-- 2. \u0412\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u0430\u044f \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u0430\u044f: \u0442\u0435\u043b\u043e = \u043e\u0434\u0438\u043d SELECT<\/span>\nCREATE<\/span> <\/span>OR<\/span> <\/span>ALTER<\/span> <\/span>FUNCTION<\/span> <\/span>dbo<\/span>.<\/span>fn_OrdersOf<\/span> (<\/span>@<\/span>customer<\/span> <\/span>nvarchar<\/span>(<\/span>50<\/span>))<\/span>\nRETURNS<\/span> <\/span>TABLE<\/span>\nAS<\/span>\nRETURN<\/span> (<\/span>\n    <\/span>SELECT<\/span> <\/span>OrderId<\/span>, <\/span>Amount<\/span>, <\/span>OrderDate<\/span>\n    <\/span>FROM<\/span> <\/span>dbo<\/span>.<\/span>Orders<\/span>\n    <\/span>WHERE<\/span> <\/span>Customer<\/span> <\/span>=<\/span> <\/span>@<\/span>customer<\/span>\n);<\/span>\nGO<\/span>\n-- 3. \u041c\u043d\u043e\u0433\u043e\u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043d\u0430\u044f \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u0430\u044f: \u0442\u0430\u0431\u043b\u0438\u0446\u0430-\u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0430\u044f + \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0439<\/span>\nCREATE<\/span> <\/span>OR<\/span> <\/span>ALTER<\/span> <\/span>FUNCTION<\/span> <\/span>dbo<\/span>.<\/span>fn_CustomerStats<\/span> ()<\/span>\nRETURNS<\/span> <\/span>@<\/span>result<\/span> <\/span>TABLE<\/span> (<\/span>Customer<\/span> <\/span>nvarchar<\/span>(<\/span>50<\/span>), <\/span>Orders<\/span> <\/span>int<\/span>, <\/span>Total<\/span> <\/span>decimal<\/span>(<\/span>12<\/span>,<\/span>2<\/span>), <\/span>Segment<\/span> <\/span>nvarchar<\/span>(<\/span>10<\/span>))<\/span>\nAS<\/span>\nBEGIN<\/span>\n    <\/span>INSERT<\/span> <\/span>INTO<\/span> <\/span>@<\/span>result<\/span> (<\/span>Customer<\/span>, <\/span>Orders<\/span>, <\/span>Total<\/span>)<\/span>\n    <\/span>SELECT<\/span> <\/span>Customer<\/span>, <\/span>COUNT<\/span>(<\/span>*<\/span>), <\/span>SUM<\/span>(<\/span>Amount<\/span>) <\/span>FROM<\/span> <\/span>dbo<\/span>.<\/span>Orders<\/span> <\/span>GROUP<\/span> <\/span>BY<\/span> <\/span>Customer<\/span>;<\/span>\n\n    <\/span>UPDATE<\/span> <\/span>@<\/span>result<\/span> <\/span>SET<\/span> <\/span>Segment<\/span> <\/span>=<\/span> <\/span>CASE<\/span> <\/span>WHEN<\/span> <\/span>Total<\/span> <\/span>>=<\/span> <\/span>3000<\/span> <\/span>THEN<\/span> <\/span>N<\/span>'VIP'<\/span> <\/span>ELSE<\/span> <\/span>N<\/span>'\u043e\u0431\u044b\u0447\u043d\u044b\u0439'<\/span> <\/span>END<\/span>;<\/span>\n    <\/span>RETURN<\/span>;<\/span>\nEND<\/span>;<\/span>\nGO<\/span>\nSELECT<\/span> <\/span>OrderId<\/span>, <\/span>Amount<\/span>, <\/span>dbo<\/span>.<\/span>fn_WithVat<\/span>(<\/span>Amount<\/span>, <\/span>DEFAULT<\/span>) <\/span>AS<\/span> <\/span>WithVat<\/span> <\/span>FROM<\/span> <\/span>dbo<\/span>.<\/span>Orders<\/span>;<\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> <\/span>dbo<\/span>.<\/span>fn_OrdersOf<\/span>(<\/span>N<\/span>'\u0410\u043d\u043d\u0430'<\/span>);<\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> <\/span>dbo<\/span>.<\/span>fn_CustomerStats<\/span>() <\/span>ORDER<\/span> <\/span>BY<\/span> <\/span>Customer<\/span>;<\/span><\/code><\/pre>\n
    \u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0442\u0440\u0435\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432: \u043a \u043a\u0430\u0436\u0434\u043e\u0439 \u0441\u0443\u043c\u043c\u0435 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d \u041d\u0414\u0421 20%, \u0434\u043b\u044f \u0410\u043d\u043d\u044b \u0432\u0435\u0440\u043d\u0443\u043b\u0438\u0441\u044c \u0434\u0432\u0430 \u0435\u0435 \u0437\u0430\u043a\u0430\u0437\u0430, \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430 \u0440\u0430\u0437\u043b\u043e\u0436\u0438\u043b\u0430 \u043a\u043b\u0438\u0435\u043d\u0442\u043e\u0432 \u043f\u043e \u0441\u0435\u0433\u043c\u0435\u043d\u0442\u0430\u043c.<\/p>\n
    OrderId | Amount  | WithVat\n1       | 1200.00 | 1440.00\n2       | 300.00  | 360.00\n3       | 5000.00 | 6000.00\n\nOrderId | Amount  | OrderDate\n1       | 1200.00 | 2026-09-01\n2       | 300.00  | 2026-09-15\n\nCustomer | Orders | Total   | Segment\n\u0410\u043d\u043d\u0430     | 2      | 1500.00 | \u043e\u0431\u044b\u0447\u043d\u044b\u0439\n\u0411\u043e\u0440\u0438\u0441    | 1      | 5000.00 | VIP\n<\/code><\/pre>\n
    \u0420\u0430\u0437\u0431\u043e\u0440 \u043f\u043e \u0432\u0438\u0434\u0430\u043c:<\/p>\n