SHARE
TWEET

Untitled




Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- CREATE DATABASE BusinessTripsUNF
- CREATE TABLE BusinessTripsUNF.dbo.ResearcherConference
- (
- rNo VARCHAR(50) NOT NULL,
- confName VARCHAR(50) NOT NULL,
- rName VARCHAR(50),
- confCity VARCHAR(50),
- confStart DATE,
- confFinish DATE,
- confSubject VARCHAR(50),
- orgNo VARCHAR(50),
- orgName VARCHAR(50),
- CONSTRAINT PK_rNo_confName PRIMARY KEY (rNo, confName)
- )
- INSERT INTO BusinessTripsUNF.dbo.ResearcherConference VALUES
- ('CR76', 'YM', 'Raymond Boyce', 'Nov', '2018-11-1', '2018-11-7', 'CS', 'C040', 'ICT'),
- ('CR76', 'Joker', 'Raymond Boyce', 'SPb', '2016-11-11', '2016-11-14', 'Java', 'C093', 'JUG.ru'),
- ('CR56', 'YM', 'Edgar Codd', 'Nov', '2017-11-2', '2017-11-8', 'CS', 'C040', 'ICT'),
- ('CR56', 'Joker', 'Edgar Codd', 'SPb', '2017-11-10', '2017-11-13', 'Java', 'C093', 'JUG.ru'),
- ('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.