When you really get to know the advanced functions in Microsoft Excel, one function that you will no doubt begin to use frequently is the IF function. In automating your calculations and data manipulation, the IF function will give you some of the same features that professional developers often use to design programs.
Pointer (PTR) resource records that are created automatically when you add a host (A or AAAA) resource record to a zone will be deleted automatically if the corresponding host (A or AAAA) resource record is deleted.You can complete this procedure using either the DNS Manager snap-in or the dnscmd command-line tool.lick OK to add the new record to the zone. To add a pointer (PTR) resource record to a reverse lookup zone using a command line. Open a command prompt. To open an elevated Command Prompt window, click Start, point to All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.
Most RDBMS's have various referential integrity rules that you can apply when you create a relationship between two tables. For example, suppose Table B has a foreign key that points to a field in Table A. Referential integrity would prevent you from adding a record to Table B that cannot be linked to Table A. In addition, the referential integrity rules might also specify that whenever you delete a record from Table A, any records in Table B that are linked to the deleted record will also be deleted.