Cobus Kruger CobusKruger

CobusKruger / gist:daff65906ea37fd979250f3526af136e

Created November 30, 2018 09:36 — forked from metaskills/gist:893599

A Copy Of sp_MSforeachtable Stored Procedure For Azure, Uses sp_MSforeach_worker


	CREATE proc [dbo].[sp_MSforeachtable]
	@command1 nvarchar(2000), @replacechar nchar(1) = N'?', @command2 nvarchar(2000) = null,
	@command3 nvarchar(2000) = null, @whereand nvarchar(2000) = null,
	@precommand nvarchar(2000) = null, @postcommand nvarchar(2000) = null
	AS
	declare @mscat nvarchar(12)
	select @mscat = ltrim(str(convert(int, 0x0002)))
	if (@precommand is not null)
	exec(@precommand)