Paul Worlton Ixalmida

Senior Software Engineer

Ixalmida / gist:80759eecd221cac64d1e01364f47af79

Created January 30, 2017 17:50 — 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)