Yurttas/PL/DBL/postgres/F/01/Company-A/DeptLocation-ins.sql

From ZCubes Wiki
Revision as of 00:41, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→‎REM REM REM DeptLocation-ins.sql REM REM: SELECT current_schema(); SET search_path to "companya"; INSERT INTO D...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 1/*
 2REM
 3REM
 4REM DeptLocation-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companya";
11
12INSERT INTO DeptLocation
13  VALUES('1', 'Houston');
14
15INSERT INTO DeptLocation
16  VALUES('4', 'Stafford');
17
18INSERT INTO DeptLocation
19  VALUES('5', 'Bellaire');
20
21INSERT INTO DeptLocation
22  VALUES('5', 'Sugarland');
23  
24INSERT INTO DeptLocation
25  VALUES('5', 'Houston');