https://virgool.io/feed/@alimilani fa 2026-04-15 09:58:43 https://static.virgool.io/images/default-avatar.jpg https://virgool.io/@alimilani https://virgool.io/@alimilani/%D9%82%D8%B7%D8%B9%D9%87-%DA%A9%D8%AF-%D9%87%D8%A7%DB%8C-%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%AF%DB%8C-%D8%AF%D8%B1-sql-shygni6luoza https://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