https://virgool.ir/feed/@alimilanifa2026-11-12 00:00:17https://virgool.ir/images/default-avatar.jpghttps://virgool.ir/@alimilanihttps://virgool.ir/@alimilani/قطعه-کد-های-کاربردی-در-sql-shygni6luozahttps://chrome.google.com/webstore/detail/majdfhpaihoncoakbjgbdhglocklcgnoساخت فانکشن در sql چگونه استبه مثال زیر توجه کنیدcreate function tarakomMaadares(@nahie nvarchar) returns numericasbegindeclare @tarakom numericSELECT @tarakom = sum([totalStudents]/ [totlaClasses])FROM madarestext231WHERE [nahie] = @nahiereturn @tarakomendcreate function tarakomMaadares5(@nahie nvarchar) returns numericasbegindeclare @tarakom numericSELECT @tarakom = sum([totalStudents]/ [totlaClasses])FROM madarestext231-- WHERE [codeMadrese] = @codeMadreseWHERE not [totlaClasses] =0 and [nahie] = @nahiereturn @tarakomendcreate function tarakomMaadares2(@codeMadrese numeric) returns numericasbegindeclare @tarakom numericSELECT @tarakom = [totalStudents]/ [totlaClasses]FROM madarestext231-- WHERE [codeMadrese] = @codeMadresereturn @tarakomendave SUM:SELECT student_code, AVG(lesson_rate) AS avg_lesson_rate , SUM(lesson_rate) AS sum_lesson_rateFROM UnitGROUP BY student_codesenSELECT student_code, DATEDIFF(year, student_birthday, GETDATE()) AS ageFROM StudentsSELECT student_code, AVG(lesson_rate) AS avg_lesson_rate , SUM(lesson_rate) AS sum_lesson_rate FROM Unit GROUP BY student_code SELECT StudentId, AVG(NomreDars) as miangin,SUM(NomreDars) as jameNomre FROM EntekhabVahed GROUP BY StudentId -- trigger CREATE TRIGGER update_total_vaheds ON EntekhabVahed AFTER UPDATE AS BEGIN DECLARE @StudentId INT; DECLARE @tedadKolVahedHa INT; SELECT @StudentId= StudentId FROM inserted PRINT @StudentId SELECT @tedadKolVahedHa= SUM(dbo.getTedadVahed(DarsId)) FROM EntekhabVahed WHERE StudentId = @StudentId GROUP BY StudentId PRINT @tedadKolVahedHa UPDATE Students SET [tedadKolVahed] = @tedadKolVahedHa WHERE StudentId = @StudentId END -- create function create FUNCTION getTedadVahed2 (@darsId INT) RETURNS INT AS BEGIN DECLARE @tedadVehd INT; SELECT @tedadVehd = TedadVahed FROM [dbo].[Dars] WHERE DarsId = @darsId RETURN @tedadVehd END غیرهcreate function tarakomMaadares(@nahie nvarchar) returns numericasbegindeclare @tarakom numericSELECT @tarakom = sum([totalStudents]/ [totlaClasses])FROM madarestext231WHERE [nahie] = @nahiereturn @tarakomendcreate function tarakomMaadares5(@nahie nvarchar) returns numericasbegindeclare @tarakom numericSELECT @tarakom = sum([totalStudents]/ [totlaClasses])FROM madarestext231-- WHERE [codeMadrese] = @codeMadreseWHERE not [totlaClasses] =0 and [nahie] = @nahiereturn @tarakomendcreate function tarakomMaadares2(@codeMadrese numeric) returns numericasbegindeclare @tarakom numericSELECT @tarakom = [totalStudents]/ [totlaClasses]FROM madarestext231-- WHERE [codeMadrese] = @codeMadresereturn @tarakomendعلیعلیSun, 11 Jun 2023 19:15:08 +0330