AD3285.PER.SG

Archive for the "MS SQL" Category

SQL – Random String

IF EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE ID = object_id(N’[dbo].[usp_RandomString]‘) AND OBJECTPROPERTY(id, N’IsProcedure’) = 1) DROP PROCEDURE [dbo].[usp_RandomString] GO CREATE PROCEDURE usp_RandomString ( @Length INTEGER ) AS BEGIN   DECLARE @ValidChar VARCHAR(255) = ‘ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890~!@#$%^&*_+’   DECLARE @Random VARCHAR(255) = ”      WHILE @Length > 0   BEGIN     SET @Length = @Length -1 [...]