|
Execute the following
script in Query Editor to create and apply an addition drills stored procedure:
USE AdventureWorks
GO
CREATE PROC MathTrainerAddition ( @DrillNumber int , @Level int, @Result bit)
AS
BEGIN
DECLARE @Counter smallint
DECLARE @Drill table (Sequence int, [Left] int, [Right] int, Result varchar(15))
SET @Counter = 1
WHILE @Counter <= @DrillNumber
BEGIN
INSERT @Drill
SELECT @Counter, @Level * RAND(), @Level* RAND(),''
SET @Counter = @Counter + 1
END
SELECT convert(varchar,Sequence)+'. '
+convert(varchar,[Left])+' + '
+ convert(varchar, [Right])+ ' = '
FROM @Drill
IF @Result = 1
BEGIN
UPDATE @Drill SET Result = convert(varchar,([Left] + [Right]))
SELECT convert(varchar,Sequence)+'. '
+convert(varchar,[Left])+' + '
+ convert(varchar, [Right])+ ' = '
+Result
FROM @Drill
END
GO
exec MathTrainerAddition 60, 30, 1
GO
|