Skip to content

Instantly share code, notes, and snippets.

View lewis-munyi's full-sized avatar

Lewis Munyi lewis-munyi

View GitHub Profile
@lewis-munyi
lewis-munyi / gist:6605d7966f74ec6708b18e0c38fbad5b
Created February 19, 2021 16:52 — 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)
@lewis-munyi
lewis-munyi / deployment_guide.md
Created January 15, 2021 20:03 — forked from vicgonvt/deployment_guide.md
Deployment Guide for Ubuntu Server from Scratch with Laravel