DAL Filter Functions by Primary Key (ID)

Database Connections

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

SELECT    SiteID, [Address 1], SiteName, [Address 2], City, Status, PostCode
FROM      Site
WHERE     (SiteID = @siteid)
SELECT    LocationTypeID, LocationTypeCaption
FROM      LocationTypes
WHERE    (LocationTypeID = @locationtypeid)
SELECT    BuildingID, BuildingName, SiteID
FROM      Buildings
WHERE    (BuildingID = @buildingid)
SELECT    LocationID, LocationEasyName, LocationTypeID, BuildingID
FROM      Locations
WHERE    (LocationID = @locationid)

Well done.

Database Connections