Public Pastes
SHARE
TWEET

Untitled

a guest Nov 14th, 2018 79 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE DATABASE BusinessTripsUNF
  2.  
  3. CREATE TABLE BusinessTripsUNF.dbo.ResearcherConference
  4. (
  5.     rNo VARCHAR(50) NOT NULL,
  6.     confName VARCHAR(50) NOT NULL,
  7.     rName VARCHAR(50),
  8.     confCity VARCHAR(50),
  9.     confStart DATE,
  10.     confFinish DATE,
  11.     confSubject VARCHAR(50),
  12.     orgNo VARCHAR(50),
  13.     orgName VARCHAR(50),
  14.     CONSTRAINT PK_rNo_confName PRIMARY KEY (rNo, confName)
  15. )
  16.  
  17. INSERT INTO BusinessTripsUNF.dbo.ResearcherConference VALUES
  18. ('CR76', 'YM', 'Raymond Boyce', 'Nov', '2018-11-1', '2018-11-7', 'CS', 'C040', 'ICT'),
  19. ('CR76', 'Joker', 'Raymond Boyce', 'SPb', '2016-11-11', '2016-11-14', 'Java', 'C093', 'JUG.ru'),
  20. ('CR56', 'YM', 'Edgar Codd', 'Nov', '2017-11-2', '2017-11-8', 'CS', 'C040', 'ICT'),
  21. ('CR56', 'Joker', 'Edgar Codd', 'SPb', '2017-11-10', '2017-11-13', 'Java', 'C093', 'JUG.ru'),
  22. ('CR56', 'SmartData', 'Edgar Codd', 'Nov', '2017-04-05', '2017-04-08', 'Data Science', 'C093', 'JUG.ru')
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top