| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Get control of your email attachments. Connect all your Gmail accounts and in less than 2 minutes, Dokkio will automatically organize your file attachments. You can also connect Dokkio to Drive, Dropbox, and Slack. Sign up for free.

View
 

Lecture - Advanced - The MyDailyMath Equation Library

Page history last edited by Dr. Ron Eaglin 8 years ago

 

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

Comments (0)

You don't have permission to comment on this page.