Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2015-09-20 17:38:03 →
Size: 359
Editor: 71-88-115-101
Comment:
← Revision 2 as of 2015-09-20 17:38:34 → ⇥
Size: 392
Editor: 71-88-115-101
Comment:
Deletions are marked like this. Additions are marked like this.
Line 7: Line 7:
SELECT *, CAST(PARSENAME(IpAddress,4) AS INT) AS A, CAST(PARSENAME(IpAddress,3) AS INT) AS B, CAST(PARSENAME(IpAddress,2) AS INT) AS C, CAST(PARSENAME(IpAddress,1) AS INT) AS D SELECT *, CAST(PARSENAME(IpAddress,4) AS INT) AS A,
          CAST(PARSENAME(IpAddress,3) AS INT) AS B,
          CAST(PARSENAME(IpAddress,2) AS INT) AS C,
          CAST(PARSENAME(IpAddress,1) AS INT) AS D

Dhcp Reservations

2015-09-20

Added a view to the DB so that we can sort on the IP address easily: 

   1 CREATE VIEW IpAddressABCD AS
   2 SELECT *, CAST(PARSENAME(IpAddress,4) AS INT) AS A,
   3           CAST(PARSENAME(IpAddress,3) AS INT) AS B,
   4           CAST(PARSENAME(IpAddress,2) AS INT) AS C,
   5           CAST(PARSENAME(IpAddress,1) AS INT) AS D
   6 FROM IpPool

CsNetworkApps/DhcpReservations (last edited 2015-09-20 17:41:43 by 71-88-115-101)