- Authentication – it is the process of ensuring the user’s identity and authenticity. ASP.Net allows four types of authentication system:
- Windows Authentication
- Forms Authentication
- Passport Authentication
- Custom Authentication
- Authorization – it is the process of defining and allotting specific roles to specific users.
- Confidentiality – it involves encrypting the channel between the client’s browser and the web server.
- Integrity – it involves maintaining the integrity of data. For example, implementing digital signature.
Method 1: -- Create Sample Table DECLARE @ table TABLE ( data VARCHAR ( 20 ) ) -- Insert Some Data INSERT INTO @ table VALUES ( 'not duplicate row' ) INSERT INTO @ table VALUES ( 'duplicate row' ) INSERT INTO @ table VALUES ( 'duplicate row' ) -- Find out Duplicate rows in table : SELECT data , COUNT ( data ) nr FROM @ table GROUP BY data HAVING COUNT ( data ) > 1 -- Remove Duplicate rows from table SET NOCOUNT ON SET ROWCOUNT 1 WHILE 1 = 1 BEGIN DELETE FROM @ table WHERE data IN ( SELECT data FROM @ table ...
Comments
Post a Comment