Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*********************************** procedure to add qualification of user ***********************************/
- CREATE PROCEDURE AddQualification @scitid VARCHAR(15), @organization VARCHAR(10), @degree VARCHAR(50), @startyear DATE, @endyear DATE, @RESULT INT OUT
- AS
- INSERT INTO Qualification(SciTID ,Organization,Degree, StartYear, EndYear) VALUES(@scitid, @organization, @degree, @startyear, @endyear)
- SET @RESULT = @@ROWCOUNT
- GO
- /******************************************************************************************************************/
- /*********************************** procedure to add work experience of user ***********************************/
- CREATE PROCEDURE AddWorkExperience @scitid VARCHAR(15), @ROLE VARCHAR(50), @Organization VARCHAR(50), @CurrentlyWorkingHere bit, @StartYear DATE, @endyear DATE, @RESULT INT OUT
- AS
- INSERT INTO WorkExperience(SciTID ,[ROLE], Organization,CurrentlyWorkingHere, StartYear, EndYear) VALUES(@scitid, @ROLE, @organization, @CurrentlyWorkingHere, @startyear, @endyear)
- SET @RESULT = @@ROWCOUNT
- GO
- /******************************************************************************************************************/
- /*********************************** procedure to add patents of user ***********************************/
- CREATE PROCEDURE AddPatents @scitid VARCHAR(15), @PatentName VARCHAR(50), @PatentNumber VARCHAR(50), @PatentOffice INT, @IssueDate DATE, @PatentStatus VARCHAR(10), @RESULT INT OUT
- AS
- INSERT INTO Patents(SciTID ,PatentName, PatentNumber,PatentOffice, IssueDate, PatentStatus) VALUES(@scitid, @PatentName, @PatentNumber, @PatentOffice, @IssueDate, @PatentStatus)
- SET @RESULT = @@ROWCOUNT
- GO
- /******************************************************************************************************************/
- /*********************************** procedure to add awards of user ***********************************/
- CREATE PROCEDURE AddAwards @scitid VARCHAR(15), @AwardTitle VARCHAR(50), @AwardedBy VARCHAR(50), @DateAwarded DATE, @Description VARCHAR(300), @RESULT INT OUT
- AS
- INSERT INTO Awards(SciTID ,AwardTitle, AwardedBy, DateAwarded, [Description]) VALUES(@scitid, @AwardTitle, @AwardedBy, @DateAwarded, @Description)
- SET @RESULT = @@ROWCOUNT
- GO
- /******************************************************************************************************************/
- /*********************************** procedure to add test scores of user ***********************************/
- CREATE PROCEDURE AddTestScore @scitid VARCHAR(15), @TestScoreTitle VARCHAR(50), @Organization VARCHAR(50), @Score VARCHAR(3), @PassDate DATE, @Description VARCHAR(300), @RESULT INT OUT
- AS
- INSERT INTO TestScore(SciTID ,TestScoreTitle, Organization, Score, PassDate, [Description]) VALUES(@scitid, @TestScoreTitle, @Organization, @Score, @PassDate, @Description)
- SET @RESULT = @@ROWCOUNT
- GO
- /******************************************************************************************************************/
- /*********************************** procedure to add voluntary organization of user ***********************************/
- CREATE PROCEDURE AddVoluntaryOrganization @scitid VARCHAR(15), @Designation VARCHAR(25), @Organization VARCHAR(50), @Location INT, @CurrentlyVolunteeringHere bit, @StartYear DATE, @EndYear DATE, @Description VARCHAR(300), @RESULT INT OUT
- AS
- INSERT INTO VoluntaryOrganization(SciTID ,Designation, Organization, [Location], CurrentlyVolunteeringHere, StartYear, EndYear, [Description]) VALUES(@scitid, @Designation, @Organization, @Location, @CurrentlyVolunteeringHere, @StartYear, @EndYear, @Description)
- SET @RESULT = @@ROWCOUNT
- GO
- /******************************************************************************************************************/
- /*********************************** procedure to add test scores of user ***********************************/
- CREATE PROCEDURE AddPublications @scitid VARCHAR(15), @PaperTitle VARCHAR(50), @DOI VARCHAR(20), @RESULT INT OUT
- AS
- INSERT INTO Publications(SciTID ,PaperTitle, DOI) VALUES(@scitid, @PaperTitle, @DOI)
- SET @RESULT = @@ROWCOUNT
- GO
- /******************************************************************************************************************/
Add Comment
Please, Sign In to add comment