Line | |
---|
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.