There are several ways you can use Python to connect to SQL Server and one of such ways is to use pyodbc and sqlalchemy Recent search terms:datapandas com
This is a sample code to use Python to connect to SQL Server Native Client.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
import sqlalchemy import pyodbc try: import urllib params = urllib.quote_plus("DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=MagicDirect;Trusted_Connection=yes;") engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params) results.to_sql("clusterSegments", engine, if_exists = 'replace')# except (RuntimeError, TypeError, NameError): print('Error in Conneccting') print(RuntimeError, TypeError, NameError) finally: print("connected") |
So I was at the SQLSaturday event in Manchester, United Kingdom on the 15th July 2017. According the SQLSaturday website, SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, and most costs are covered by donations and sponsorships. I would,
If you have ever worked with Java, Python, R, SQL, Excel and other Languages on a varied Data Science or Data Analytics projects, you will realise that all these languages have similar syntaxes, or at least, can achieve the same objective with very similar codes. Below is a comparison and similarities of these various tools
In this short article, we look at a sample ERD Diagram which is designed using ER-Assistant software (usage of this software is covered here: How To Use ER Assistant) after we have finished with the Conceptual Modeling. Hence in the first place, we have to gather some Data requirements. This involves business logic and requirements,
Understading cardinality notation and being able to explain them will go a long way in your database design and implementation. Here we look at a simple explanation of the symbols. (Credit to Data Warehousing for Business Intelligence by University of Colorado System on Coursera) Symbols in the above diagram and their meanings: – Oval: means 0 –
Which Part of SQL Statements Execute First and in What Order. It is very important to understand which parts of the SQL Statement executes first and which part comes next until full completion. The diagram below gives an overview of the execution order. The steps in which the SQL statement is executed are as below:
ERDPLUS One tool I generally use when working on a projects, mini tasks and exploration is the ERDPLUS tool . It is quite simple and easy to use. It is a Free tool as well. Below are some diagrams I generated when i first got in contact with with tool. ERD DIAGRAMS: 1. 2. A
Creating Oracle tables for Intercollegiate Athletic Database. Part of Assignment one of Data Warehousing for Business Intelligence on Coursera
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 |
--1 CREATE TABLE FACILITY CREATE TABLE FACILITY( FACNO VARCHAR(12), FACNAME VARCHAR(255) NOT NULL, CONSTRAINT PK_FAC PRIMARY KEY (FACNO) ); --2.REATE TABLE EMPLOYEE CREATE TABLE EMPLOYEE( EMPNO VARCHAR(12), EMPNAME VARCHAR(255) NOT NULL, DEPARTMENT VARCHAR(100) NOT NULL, EMAIL VARCHAR(50) NOT NULL, PHONE VARCHAR(30) NOT NULL, CONSTRAINT PK_EMP PRIMARY KEY (EMPNO), CONSTRAINT CHK_EMP CHECK(LENGTHB(PHONE) BETWEEN 5 AND 30) ); --3 RESOURCETBL CREATE TABLE RESOURCETBL( RESNO VARCHAR(12), RESNAME VARCHAR(255) NOT NULL, RATE NUMBER(8,2) NOT NULL, CONSTRAINT PK_RES PRIMARY KEY (RESNO) ); /* ALTER TABLE CUSTOMER drop constraint CHK_CUS_ZIP; ALTER TABLE CUSTOMER ADD CONSTRAINT CHK_CUS_ZIP CHECK(LENGTHB(ZIP) <=10) */ --4 CUSTOMER CREATE TABLE CUSTOMER( CUSTNO VARCHAR(12), CUSTNAME VARCHAR(255) NOT NULL, ADDRESS VARCHAR(255) NOT NULL, INTERNAL CHAR(1) NOT NULL, CONTACT VARCHAR(255) NOT NULL, PHONE VARCHAR(30) NOT NULL, CITY VARCHAR(50) NOT NULL, STATE CHAR(2) NOT NULL, ZIP INTEGER NOT NULL, CONSTRAINT PK_CUS PRIMARY KEY (CUSTNO), CONSTRAINT CHK_CUS CHECK (LENGTHB(PHONE) BETWEEN 5 AND 30), CONSTRAINT CHK_CUS_ZIP CHECK(LENGTHB(ZIP) <=10) ); --5 LOCATION CREATE TABLE LOCATION( LOCNO VARCHAR(12), FACNO VARCHAR(12), LOCNAME VARCHAR(255) NOT NULL, CONSTRAINT PK_LOC PRIMARY KEY (LOCNO), CONSTRAINT FK_LOC FOREIGN KEY (FACNO) REFERENCES FACILITY ); -- 6 EVENTREQUEST CREATE TABLE EVENTREQUEST( EVENTNO VARCHAR(12), DATEHELD DATE NOT NULL, DATEREQ DATE NOT NULL, CUSTNO VARCHAR(12), FACNO VARCHAR(12), DATEAUTH DATE NOT NULL, STATUS VARCHAR(20) NOT NULL, ESTCOST NUMBER(8,2) NOT NULL, ESTAUDIENCE INTEGER NOT NULL, BUDNO VARCHAR(12), CONSTRAINT PK_EVR PRIMARY KEY (EVENTNO), CONSTRAINT FK_EVR_CUS FOREIGN KEY (CUSTNO) REFERENCES CUSTOMER, CONSTRAINT FK_EVR_FAC FOREIGN KEY (FACNO) REFERENCES FACILITY, CONSTRAINT CHK_AUD CHECK(ESTAUDIENCE >= 1), CONSTRAINT CHK_STU CHECK(STATUS IN ('Approved', 'Pending', 'Denied')) ); /** LET'S ALLOW NULL VALUES IN THE AUTHORISED DATE, AS we might not as yet have an authorised date**/ ALTER TABLE EVENTREQUEST MODIFY ( DATEAUTH NULL ); --7 EVENTPLAN CREATE TABLE EVENTPLAN( PLANNO VARCHAR(12), EVENTNO VARCHAR(12), WORKDATE DATE NOT NULL, NOTES VARCHAR(1000) NOT NULL, ACTIVITY VARCHAR(500) NOT NULL, EMPNO VARCHAR(12), CONSTRAINT PK_EVP PRIMARY KEY (PLANNO), CONSTRAINT FK_EVP_EVR FOREIGN KEY (EVENTNO) REFERENCES EVENTREQUEST ); /*ALLOW NULL VALUES IN NOTES COLUMN*/ ALTER TABLE EVENTPLAN MODIFY ( NOTES NULL ); -- 8 EVENTPLANLINE CREATE TABLE EVENTPLANLINE( PLANNO VARCHAR(12), LINENO INTEGER NOT NULL, TIMESTART DATE NOT NULL, TIMEEND DATE NOT NULL, NUMBERFLD INTEGER NOT NULL, LOCNO VARCHAR(12), RESNO VARCHAR(12), CONSTRAINT PK_EVPLL PRIMARY KEY (PLANNO, LINENO), CONSTRAINT FK_EVPLL_EVP FOREIGN KEY (PLANNO) REFERENCES EVENTPLAN, CONSTRAINT FK_EVPLL_LOC FOREIGN KEY (LOCNO) REFERENCES LOCATION, CONSTRAINT FK_EVPLL_RES FOREIGN KEY (RESNO) REFERENCES RESOURCETBL ); |
After creating the tables lets insert values
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 |
--INSERT RECORDS INTO EVENTPLANLINE Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P100',1, to_date('25-OCT-13 8:00:00','DD-MON-RR HH24:MI:SS'), to_date('25-OCT-13 17:00:00','DD-MON-RR HH24:MI:SS'),2,'L100','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P100',2, to_date('25-OCT-13 12:00:00','DD-MON-RR HH24:MI:SS'),to_date('25-OCT-13 17:00:00','DD-MON-RR HH24:MI:SS'), 2,'L101','R101'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P100',3, to_date('25-OCT-13 7:00:00','DD-MON-RR HH24:MI:SS'), to_date('25-OCT-13 16:30:00','DD-MON-RR HH24:MI:SS'), 1,'L102','R102'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P100',4, to_date('25-OCT-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('25-OCT-13 22:00:00','DD-MON-RR HH24:MI:SS'),2,'L100','R102'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P101',1, to_date('3-DEC-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('3-DEC-13 20:00:00','DD-MON-RR HH24:MI:SS'),2,'L103','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P101',2, to_date('3-DEC-13 18:30:00','DD-MON-RR HH24:MI:SS'),to_date('3-DEC-13 19:00:00','DD-MON-RR HH24:MI:SS'),4,'L105','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P101',3, to_date('3-DEC-13 19:00:00','DD-MON-RR HH24:MI:SS'),to_date('3-DEC-13 20:00:00','DD-MON-RR HH24:MI:SS'),2,'L103','R103'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P102',1, to_date('5-DEC-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('5-DEC-13 19:00:00','DD-MON-RR HH24:MI:SS'),2,'L103','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P102',2, to_date('5-DEC-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('5-DEC-13 21:00:00','DD-MON-RR HH24:MI:SS'),4,'L105','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P102',3, to_date('5-DEC-13 19:00:00','DD-MON-RR HH24:MI:SS'),to_date('5-DEC-13 22:00:00','DD-MON-RR HH24:MI:SS'),2,'L103','R103'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P103',1, to_date('12-DEC-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('12-DEC-13 21:00:00','DD-MON-RR HH24:MI:SS'),2,'L103','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P103',2, to_date('12-DEC-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('12-DEC-13 21:00:00','DD-MON-RR HH24:MI:SS'),4,'L105','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P103',3, to_date('12-DEC-13 19:00:00','DD-MON-RR HH24:MI:SS'),to_date('12-DEC-13 22:00:00','DD-MON-RR HH24:MI:SS'),2,'L103','R103'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P104',1, to_date('26-OCT-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('26-OCT-13 22:00:00','DD-MON-RR HH24:MI:SS'),4,'L101','R104'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P104',2, to_date('26-OCT-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('26-OCT-13 22:00:00','DD-MON-RR HH24:MI:SS'),4,'L100','R104'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P105',1, to_date('25-OCT-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('25-OCT-13 22:00:00','DD-MON-RR HH24:MI:SS'),4,'L101','R104'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P105',2, to_date('25-OCT-13 18:00:00','DD-MON-RR HH24:MI:SS'),to_date('25-OCT-13 22:00:00','DD-MON-RR HH24:MI:SS'),4,'L100','R104'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P199',1, to_date('10-DEC-13 8:00:00','DD-MON-RR HH24:MI:SS'), to_date('10-DEC-13 12:00:00','DD-MON-RR HH24:MI:SS'),1,'L100','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P349',1, to_date('12-DEC-13 12:00:00','DD-MON-RR HH24:MI:SS'),to_date('12-DEC-13 15:30:00','DD-MON-RR HH24:MI:SS'),1,'L103','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P85',1, to_date('25-OCT-13 9:00:00','DD-MON-RR HH24:MI:SS'), to_date('25-OCT-13 17:00:00','DD-MON-RR HH24:MI:SS'),5,'L100','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P85',2, to_date('25-OCT-13 8:00:00','DD-MON-RR HH24:MI:SS'), to_date('25-OCT-13 17:00:00','DD-MON-RR HH24:MI:SS'),2,'L102','R101'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P85',3, to_date('25-OCT-13 10:00:00','DD-MON-RR HH24:MI:SS'), to_date('25-OCT-13 15:00:00','DD-MON-RR HH24:MI:SS'),3,'L104','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P95',1, to_date('26-OCT-13 8:00:00','DD-MON-RR HH24:MI:SS'), to_date('26-OCT-13 17:00:00','DD-MON-RR HH24:MI:SS'),4,'L100','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P95',2, to_date('26-OCT-13 9:00:00','DD-MON-RR HH24:MI:SS'), to_date('26-OCT-13 17:00:00','DD-MON-RR HH24:MI:SS'),4,'L102','R101'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P95',3, to_date('26-OCT-13 10:00:00','DD-MON-RR HH24:MI:SS'), to_date('26-OCT-13 15:00:00','DD-MON-RR HH24:MI:SS'),4,'L106','R100'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P95',4, to_date('26-OCT-13 13:00:00','DD-MON-RR HH24:MI:SS'), to_date('26-OCT-13 17:00:00','DD-MON-RR HH24:MI:SS'),2,'L100','R103'); Insert into EVENTPLANLINE (PLANNO,LINENO,TIMESTART,TIMEEND,NUMBERFLD,LOCNO,RESNO) values ('P95',5, to_date('26-OCT-13 13:00:00','DD-MON-RR HH24:MI:SS'), to_date('26-OCT-13 17:00:00','DD-MON-RR HH24:MI:SS'),2,'L101','R104'); -- INSERT RECORDS INTO EVENTPLAN TABLE Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P100','E100','25-OCT-13','Standard operation','Operation','E102'); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P101','E104','03-DEC-13','Watch for gate crashers','Operation','E100'); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P102','E105','05-DEC-13','Standard operation','Operation','E102'); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P103','E106','12-DEC-13','Watch for seat switching','Operation',null); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P104','E101','26-OCT-13','Standard cleanup','Cleanup','E101'); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P105','E100','25-OCT-13','Light cleanup','Cleanup','E101'); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P199','E102','10-DEC-13','ABC','Operation','E101'); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P299','E101','26-OCT-13',null,'Operation','E101'); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P349','E106','12-DEC-13',null,'Setup','E101'); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P85','E100','25-OCT-13','Standard operation','Cleanup','E102'); Insert into EVENTPLAN (PLANNO,EVENTNO,WORKDATE,NOTES,ACTIVITY,EMPNO) values ('P95','E101','26-OCT-13','Extra security','Cleanup','E102'); -- INSERT RECORDS INTO EVENTREQUEST Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E100','25-OCT-13','06-JUN-13','C100','F100','08-JUN-13','Approved',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E101','26-OCT-13','28-JUL-13','C100','F100','','Pending',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E103','21-SEP-13','28-JUL-13','C100','F100','01-AUG-13','Approved',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E102','14-SEP-13','28-JUL-13','C100','F100','31-JUL-13','Approved',5000,80000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E104','03-DEC-13','28-JUL-13','C101','F101','31-JUL-13','Approved',2000,12000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E105','05-DEC-13','28-JUL-13','C101','F101','01-AUG-13','Approved',2000,10000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E106','12-DEC-13','28-JUL-13','C101','F101','31-JUL-13','Approved',2000,10000,'B1000'); Insert into EVENTREQUEST (EVENTNO,DATEHELD,DATEREQ,CUSTNO,FACNO,DATEAUTH,STATUS,ESTCOST,ESTAUDIENCE,BUDNO) values ('E107','23-NOV-13','28-JUL-13','C105','F100','31-JUL-13','Denied',10000,5000,null); -- INSERT RECORDS INTO LOCATION Insert into LOCATION (LOCNO,FACNO,LOCNAME) values ('L100','F100','Locker room'); Insert into LOCATION (LOCNO,FACNO,LOCNAME) values ('L101','F100','Plaza'); Insert into LOCATION (LOCNO,FACNO,LOCNAME) values ('L102','F100','Vehicle gate'); Insert into LOCATION (LOCNO,FACNO,LOCNAME) values ('L103','F101','Locker room'); Insert into LOCATION (LOCNO,FACNO,LOCNAME) values ('L104','F100','Ticket Booth'); Insert into LOCATION (LOCNO,FACNO,LOCNAME) values ('L105','F101','Gate'); Insert into LOCATION (LOCNO,FACNO,LOCNAME) values ('L106','F100','Pedestrian gate'); -- INSERT RECORDS INTO FACILITY Insert into FACILITY (FACNO,FACNAME) values ('F100','Football stadium'); Insert into FACILITY (FACNO,FACNAME) values ('F101','Basketball arena'); Insert into FACILITY (FACNO,FACNAME) values ('F102','Baseball field'); Insert into FACILITY (FACNO,FACNAME) values ('F103','Recreation room'); -- INSERT RECORDS into RESOURCETBL Insert into RESOURCETBL (RESNO,RESNAME,RATE) values ('R100','attendant',10); Insert into RESOURCETBL (RESNO,RESNAME,RATE) values ('R101','police',15); Insert into RESOURCETBL (RESNO,RESNAME,RATE) values ('R102','usher',10); Insert into RESOURCETBL (RESNO,RESNAME,RATE) values ('R103','nurse',20); Insert into RESOURCETBL (RESNO,RESNAME,RATE) values ('R104','janitor',15); Insert into RESOURCETBL (RESNO,RESNAME,RATE) values ('R105','food service',10); -- insert records into CUSTOMER TABLE Insert into CUSTOMER (CUSTNO,CUSTNAME,ADDRESS,INTERNAL,CONTACT,PHONE,CITY,STATE,ZIP) values ('C100','Football','Box 352200','Y','Mary Manager','6857100','Boulder','CO','80309'); Insert into CUSTOMER (CUSTNO,CUSTNAME,ADDRESS,INTERNAL,CONTACT,PHONE,CITY,STATE,ZIP) values ('C101','Men''s Basketball','Box 352400','Y','Sally Supervisor','5431700','Boulder','CO','80309'); Insert into CUSTOMER (CUSTNO,CUSTNAME,ADDRESS,INTERNAL,CONTACT,PHONE,CITY,STATE,ZIP) values ('C103','Baseball','Box 352020','Y','Bill Baseball','5431234','Boulder','CO','80309'); Insert into CUSTOMER (CUSTNO,CUSTNAME,ADDRESS,INTERNAL,CONTACT,PHONE,CITY,STATE,ZIP) values ('C104','Women''s Softball','Box 351200','Y','Sue Softball','5434321','Boulder','CO','80309'); Insert into CUSTOMER (CUSTNO,CUSTNAME,ADDRESS,INTERNAL,CONTACT,PHONE,CITY,STATE,ZIP) values ('C105','High School Football','123 AnyStreet','N','Coach Bob','4441234','Louisville','CO','80027'); -- insert records into EMPLOYEE TABLE Insert into EMPLOYEE (EMPNO,EMPNAME,DEPARTMENT,EMAIL,PHONE) values ('E100','Chuck Coordinator','Administration','chuck@colorado.edu','3-1111'); Insert into EMPLOYEE (EMPNO,EMPNAME,DEPARTMENT,EMAIL,PHONE) values ('E101','Mary Manager','Football','mary@colorado.edu','5-1111'); Insert into EMPLOYEE (EMPNO,EMPNAME,DEPARTMENT,EMAIL,PHONE) values ('E102','Sally Supervisor','Planning','sally@colorado.edu','3-2222'); Insert into EMPLOYEE (EMPNO,EMPNAME,DEPARTMENT,EMAIL,PHONE) values ('E103','Alan Administrator','Administration','alan@colorado.edu','3-3333'); |
In case you want to change a constraint on a field, you can use a syntax examples as the following. ALTER TABLE FACILITY ADD CONSTRAINT UNQ_FAC UNIQUE (FACNAME)
The following are the main constraints which can be defined when you are creating a TABLE. I will be using the ORACLE DBMS . Primary key – The primary key of the table to be created. Foreign key – The primary key of some other table which is being referenced in this table to be
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/
