Skip to content

Instantly share code, notes, and snippets.

@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)
Microsoft (R) Build Engine version 15.8.169+g1ccb72aefa for .NET Framework
Copyright (C) Microsoft Corporation. All rights reserved.
Build started 17/10/2018 21:42:33.
Search paths being used for $(MSBuildExtensionsPath) are C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\MSBuild;$(MSBuildProgramFiles32)\MSBuild
Trying to import C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\MSBuild\$(MSBuildToolsVersion)\Microsoft.Common.props using extensions path C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\MSBuild
Property reassignment: $(MSBuildProjectExtensionsPath)="C:\corert\bin\obj\Native\Windows_NT.x64.Debug\CMakeFiles\3.11.18040201-MSVC_2\obj\" (previous value: "obj\") at C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\MSBuild\15.0\Microsoft.Common.props (60,5)
Search paths being used for $(MSBuildExtensionsPath) are C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\MSBuild;$(MSBuildProgramFiles32)\MSBuild
Trying to import C:\Pr