Applying security for a web application is a very common task. There are always parts on a web site that requires private only access for members. Recently, I tried to use the form authentication method provided by .NET and found it quite simple to use, though I have always done it with sessions. The
These are some of the commonly used SQL queries at work, just to note them down for easier access. To add a contraint (foreign key): alter table pro_product add constraint FK_53_PRO_Category_FK foreign key (PRO_Category_FK) references PRO_Category(Id) on delete cascade