Pinned Loading

1. SQL Server: TSQL Callstack Emulation SQL Server: TSQL Callstack Emulation

   1

   IF OBJECT_ID('dbo.ErrorHandler') IS NULL BEGIN 

   2

     EXEC ('CREATE PROCEDURE dbo.ErrorHandler AS BEGIN SELECT 1; END;');

   3

   END

   4

   GO

   5

2. Possible bad SQL SERVER OPTIONS in s... Possible bad SQL SERVER OPTIONS in server, db, tables, procs, columns

   1

   --SELECT * FROM sys.databases

   2

   3

   SELECT 'SERVER OPTIONS' AS 'container' 

   4

   5

   /*

3. jsonb_generic.sql jsonb_generic.sql

   1

   DROP TABLE IF EXISTS pgbench_generic_log;

   2

   CREATE TABLE pgbench_generic_log (

   3

     mtime timestamptz not null default now(),

   4

     action char not null check (action in ('I', 'U', 'D')),

   5

     username text not null,

4. fun with IP Addresses in MSSQL fun with IP Addresses in MSSQL

   1

   CREATE FUNCTION dbo.udf_ipv4_format (@addr binary(16) )

   2

   RETURNS varchar(20) with SCHEMABINDING AS

   3

   BEGIN 

   4

   return IIF(SUBSTRING(@addr,0,8)=0,

   5

   			CONCAT( 

5. SqlServer.Rules SqlServer.Rules Public

   Forked from tcartwright/SqlServer.Rules

   SQL Server static code analysis rules for SSDT database projects

   C#

6. tsql-tips-n-tricks tsql-tips-n-tricks Public

   grab bag of fun or educational tsql