4. Clear the check box for Allow Nulls. (Web host forum)
4. Clear the check box for Allow Nulls. 5. In the Column Properties pane, click + next to Identity Specification. 6. Set the (Is Identity) property to Yes. You can leave the Identity Increment and Identity Seed fields each set to one. 7. Right-click the SiteId field name and choose Set Primary Key. Figure 11-37 shows the table structure so far, with just the auto-numbered primary key SiteId defined. 8. Add a second field to store the site s title. For my example, I ll name that field SiteName and set its Data Type to nvarchar(50). 9. Add a third field for storing the site s URL. In my example, I ll name it SiteURL and give it the varchar Data Type with a maximum length of 64 characters. Figure 11-38 shows my completed table structure. 10. Click Close in the upper-right corner of the Design surface. 11. When asked about saving the table, choose Yes. 12. Name the table Links and click OK. Figure 11-38: Structure of my sample Links table. Figure 11-37: The primary key for a table of hyperlinks. 258 Part III: Personalization and Databases
Check Tomcat Web Hosting services for best quality webspace to host your web application.