Chris Fernando seefernando
seefernando
/ sp_MSforeach_worker.sql
Last active
March 30, 2021 08:55
— forked from metaskills/gist:893599
A Copy Of sp_MSforeachtable Stored Procedure For Azure, Uses sp_MSforeach_worker
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create proc dbo.sp_MSforeach_worker | |
| @command1 nvarchar(2000), @replacechar nchar(1) = N'?', @command2 nvarchar(2000) = null, @command3 nvarchar(2000) = null, @worker_type int =1 | |
| as | |
| create table #qtemp ( -- Temp command storage -- | |
| qnum int NOT NULL, | |
| qchar nvarchar(2000) COLLATE database_default NULL | |
| ) | |