Rev | Line | |
---|
[1240] | 1 | DROP TABLE EDP.SiteMapper
|
---|
| 2 |
|
---|
| 3 | CREATE TABLE EDP.SiteMapper(
|
---|
| 4 | siteCode VARCHAR(30) NOT NULL,
|
---|
| 5 | sitePrefix VARCHAR(100) NOT NULL UNIQUE
|
---|
| 6 | )
|
---|
| 7 |
|
---|
| 8 | DELETE FROM EDP.SiteMapper
|
---|
| 9 | DELETE FROM EDP.SiteMapper where sitePrefix='ISL'
|
---|
| 10 |
|
---|
| 11 |
|
---|
| 12 | INSERT INTO EDP.SiteMapper VALUES('442','ISL-DHARS1-LT.vha.med.va.gov')
|
---|
| 13 |
|
---|
| 14 | UPDATE EDP.SiteMapper SET sitePrefix='ISL' WHERE siteCode='442'
|
---|
| 15 |
|
---|
| 16 | select siteCode from EDP.SiteMapper where sitePrefix='ISL-DHARS1-LT.vha.med.va.gov'
|
---|
| 17 |
|
---|
| 18 |
|
---|
| 19 |
|
---|
| 20 |
|
---|
| 21 |
|
---|
| 22 |
|
---|
| 23 |
|
---|
| 24 |
|
---|
| 25 |
|
---|
| 26 |
|
---|
| 27 |
|
---|
| 28 |
|
---|
| 29 | DROP TABLE EDP.SiteMapper
|
---|
| 30 |
|
---|
| 31 | CREATE TABLE EDP.SiteMapper(
|
---|
| 32 | siteCode VARCHAR(30) NOT NULL,
|
---|
| 33 | sitePrefix VARCHAR(100) NOT NULL UNIQUE
|
---|
| 34 | )
|
---|
| 35 |
|
---|
| 36 |
|
---|
| 37 | INSERT INTO EDP.SiteMapper VALUES('442','ISL')
|
---|
| 38 | INSERT INTO EDP.SiteMapper VALUES('660','MOC')
|
---|
Note:
See
TracBrowser
for help on using the repository browser.