The My Daily Math Equation Library
Prerequisites
Case Study – My Daily Math
Summary
Video
Reference Materials
USE MyDailyMath
GO
CREATE TABLE EquationLibrary (
id INT PRIMARY KEY IDENTITY(1,1),
TaxonomyID INT FOREIGN KEY REFERENCES Taxonomies(id),
EquationTitle VARCHAR(255),
EquationText NVARCHAR(MAX),
EquationFormat VARCHAR(50),
EnteredDate DateTime,
Entered
ByUserID INT FOREIGN KEY REFERENCES Users(id))
GO
CREATE PROCEDURE sp_InsertEquation (
@TaxonomyID INT = NULL,
@EquationTitle VARCHAR(255),
@EquationText NVARCHAR(MAX),
@EquationFormat VARCHAR(50) = 'MathML',
@EnteredByUserID INT = 0 )
AS
BEGIN
INSERT INTO EquationLibrary
(TaxonomyID, EquationTitle, EquationText, EquationFormat, EnteredDate, EnteredByUserID)
VALUES
(@TaxonomyID, @EquationTitle, @EquationText, @EquationFormat, GETDATE(), @EnteredByUserID)
RETURN @@IDENTITY
END
GO
CREATE PROCEDURE sp_UpdateEquation (
@id INT,
@TaxonomyID INT = NULL,
@EquationTitle VARCHAR(255),
@EquationText NVARCHAR(MAX),
@EquationFormat VARCHAR(50) = 'MathML',
EntereddByUserID INT = 1 )
AS
BEGIN
UPDATE EquationLibrary
SET
TaxonomyID = @TaxonomyID,
EquationTitle = @EquationTitle,
EquationText = @EquationText,
EquationFormat = @EquationFormat,
EnteredDate = GETDATE(),
EnteredByUserID = @EnterdByUserID
WHERE
id = @id
END
Additional Information
COP 4834 Lectures Page
