Tilføjelse til nedenstående SQL scripts hvis rettelse skal begrænses ud fra stationering. Dvs. at der rettes kun for pågældende vejnavn mellem FraStat og TilStat.

and
Cracking.[From Reference Point] >= FraStat 
and
Cracking.[To Reference Point] <= TilStat


Ret vejnummer i Cracking:

update Cracking 
set 
Cracking.[Road number] = 'NYT VEJNUMMER'
where 
Cracking.[Road number] = 'GAMMELT VEJNUMMER'
__________________________________________________
and
Cracking.[From Reference Point] >= FraStat 
and
Cracking.[To Reference Point] <= TilStat
__________________________________________________


Ret vejnummer i Guard Rails:

update "Guard Rails" 
set 
"Guard Rails".[Roadnumber] = 'NYT VEJNUMMER'
where 
"Guard Rails".[Roadnumber] = 'GAMMELT VEJNUMMER'
__________________________________________________
and
"Guard Rails".[FromReferencePoint] >= FraStat 
and
"Guard Rails".[ToReferencePoint] <= TilStat
__________________________________________________



Ret vejnummer i Light Poles:

update "Light Poles" 
set 
"Light Poles".[Roadnumber] = 'NYT VEJNUMMER'
where 
"Light Poles".[Roadnumber] = 'GAMMELT VEJNUMMER'
__________________________________________________
and
"Light Poles".[ReferencePoint] >= FraStat 
and
"Light Poles".[ReferencePoint] <= TilStat
__________________________________________________


Ret vejnummer i Potholes:

update Potholes 
set 
Potholes.[Road number] = 'NYT VEJNUMMER'
where 
Potholes.[Road number] = 'GAMMELT VEJNUMMER'
__________________________________________________
and
Potholes.[Reference Point] >= FraStat 
and
Potholes.[Reference Point] <= TilStat
__________________________________________________


Ret vejnummer i Reference Poles:

update "Reference Poles" 
set 
"Reference Poles".[Roadnumber] = 'NYT VEJNUMMER'
where 
"Reference Poles".[Roadnumber] = 'GAMMELT VEJNUMMER'
__________________________________________________
and
"Reference Poles".[ReferencePoint] >= FraStat 
and
"Reference Poles".[ReferencePoint] <= TilStat
__________________________________________________


Ret vejnummer i Sensor:

update Sensor 
set 
Sensor.[Road number] = 'NYT VEJNUMMER'
where 
Sensor.[Road number] = 'GAMMELT VEJNUMMER'
__________________________________________________
and
Sensor.[From Reference Point] >= FraStat 
and
Sensor.[To Reference Point] <= TilStat
__________________________________________________


Ret vejnummer i Signs:

update Signs 
set 
Signs.[Roadnumber] = 'NYT VEJNUMMER'
where 
Signs.[Roadnumber] = 'GAMMELT VEJNUMMER'
__________________________________________________
and
Signs.[ReferencePoint] >= FraStat 
and
Signs.[ReferencePoint] <= TilStat
__________________________________________________


Ret vejnummer i Traffic Lights:

update "Traffic Lights" 
set 
"Traffic Lights".[Roadnumber] = 'NYT VEJNUMMER'
where 
"Traffic Lights".[Roadnumber] = 'GAMMELT VEJNUMMER'
__________________________________________________
and
"Traffic Lights".[ReferencePoint] >= FraStat 
and
"Traffic Lights".[ReferencePoint] <= TilStat
__________________________________________________



Se alle oplysninger om bestemt vejnummer:

select * from Cracking where 
Cracking.[Road number] = '5033360'