{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["macSQL"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"macSQL","index":0,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Suppose that you want to populate the following database table using SQL Insert statements:"]
[]
[null,null,null,"Drop Database If Exists Company;"]
[null,null,null,"Create Database Company;"]
[null,null,null,"Use Company;"]
[null,null,null,"Create Table Employee"]
[null,null,null,"("]
[null,null,null,"  num int primary key,"]
[null,null,null,"  firstName VarChar(20),"]
[null,null,null,"  lastName VarChar(20),"]
[null,null,null,"  dob datetime,"]
[null,null,null,"  salary decimal(8,2)"]
[null,null,null,");"]
[]
[null,null,null,"In order to use the sqlInsert( ) macro function, you would need to organize you data in the followng way:"]
[null,null,null,"Notice that numeric columns are marked up with n and other columns are marked up with c"]
[]
[null,null,null,"Employee"]
[null,null,null,"n","c","c","c","n"]
[null,"dob",null,"num","firstName","lastName","dob","salary"]
[null,"1965-12-01T05:00:00",null,1,"Ann","Annison",{"$f":"TEXT(B22,\"yyy/mm/dd hh:MM\")","v":"1965/12/01 05:00"},125546.87,null,{"$f":"sqlInsert($D$19,$D$20:$H$21,D22:H22)","v":"Insert into Employee(num,firstName,lastName,dob,salary) Values(1,'Ann','Annison','1965/12/01 05:00',125546.87);"}]
[null,"1970-11-02T21:00:00",null,2,"Ben","Benford",{"$f":"TEXT(B23,\"yyy/mm/dd hh:MM\")","v":"1970/11/02 21:00"},70126.39,null,{"$f":"sqlInsert($D$19,$D$20:$H$21,D23:H23)","v":"Insert into Employee(num,firstName,lastName,dob,salary) Values(2,'Ben','Benford','1970/11/02 21:00',70126.39);"}]
[null,"1980-10-03T15:00:00",null,3,"Cop","Copski",{"$f":"TEXT(B24,\"yyy/mm/dd hh:MM\")","v":"1980/10/03 15:00"},130167.38,null,{"$f":"sqlInsert($D$19,$D$20:$H$21,D24:H24)","v":"Insert into Employee(num,firstName,lastName,dob,salary) Values(3,'Cop','Copski','1980/10/03 15:00',130167.38);"}]
[null,"1981-05-06T07:35:00",null,4,"Eve","Evenbauer","1981/05/06 07:35",97679.83,null,{"$f":"sqlInsert($D$19,$D$20:$H$21,D25:H25)","v":"Insert into Employee(num,firstName,lastName,dob,salary) Values(4,'Eve','Evenbauer','1981/05/06 07:35',97679.83);"}]