pakomp

pakomp / Enums.php

Created May 26, 2017 09:13 — forked from jhoff/Enums.php

Laravel Model Enumeration Trait

	<?php

	namespace App\Traits;

	use Illuminate\Support\Str;
	use App\Exceptions\InvalidEnumException;

	trait Enums
	{
	/**

pakomp / gist:d651fa543a7f82ef3a39d11dc489251d

Created March 8, 2017 13:23 — 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)