January 5, 2017

Using REPLICATE for SQL Strings

The following example replicates a # character five times in front of a Student Number in the Students table: SELECT [Student Name], REPLICATE(‘#’, 5) + [Student Number] AS ‘Student Number’FROM [Students]GOHere is an example result set.Student Name Student NumberTest Name 1 – #####STU1Test Name 2 – #####STU2Test Name 3 –

Web Application Security Testing Tools

When handling sensitive user data, it is important to test the security of your Web application before deploying it to the production environment. There are many tools that can help you speed up this process. In this article, we will mention the most widely used ones. Open Source vs. Commercial