﻿--Migration
DROP VIEW IF EXISTS dbo.getRand;
GO

DROP VIEW IF EXISTS dev.vGetRand;
GO

CREATE VIEW dev.vGetRand AS 
  SELECT RAND(CHECKSUM(NEWID())) AS RandomNumber
GO

EXEC [dbo].[sp_Global_DeleteFunctions]
	@pSchemaName = NULL, 
	@pFunctionNames = '<FunctionNames><FunctionName>fnConvertBase64</FunctionName></FunctionNames>'

DROP FUNCTION IF EXISTS dbo.fnConvertBase64
GO

EXEC [dbo].[sp_Global_DeleteStoredProcedures]
	@pSchemaName = NULL, -- pl: 'KR_BEDO_Schema' | NULL esetén az összes sémán végigmegy
	@pStoredProcedureNames = '<StoredProcedureNames><StoredProcedureName>sp_GenerateNewSHA1PasswordUserFromString</StoredProcedureName></StoredProcedureNames>'

DROP PROCEDURE IF EXISTS dbo.sp_GenerateNewSHA1PasswordUserFromString
GO

