Differences between revisions 2 and 3
⇤ ← Revision 2 as of 2015-09-20 17:38:34 →
Size: 392
Editor: 71-88-115-101
Comment:
← Revision 3 as of 2015-09-20 17:40:01 → ⇥
Size: 389
Editor: 71-88-115-101
Comment:
Deletions are marked like this. Additions are marked like this.
Line 6: Line 6:
CREATE VIEW IpAddressABCD AS CREATE VIEW IpPoolABCD AS

Dhcp Reservations

2015-09-20

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

   1 CREATE VIEW IpPoolABCD 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)