Skip to content

Instantly share code, notes, and snippets.

-- usage 1: EXEC lb_util_comment_table N'stock_location', N'Stores history of GPS co-ordinates for stock items';
-- usage 2: EXEC lb_util_comment_column @TableName=N'stock_location', @ColumnName=N'measured_at', N'datestamp of location measured';
CREATE OR ALTER procedure lb_util_comment_column @TableName SYSNAME,
@ColumnName nvarchar(200),
@MS_DescriptionValue nvarchar(200)
as
declare @MS_Description nvarchar(200) = null;
@tom-haines
tom-haines / TestDomainSend.java
Created February 17, 2020 06:44
Example send via google domain-wide delegation in GSuite
import com.google.api.client.googleapis.auth.oauth2.GoogleCredential;
import com.google.api.client.googleapis.javanet.GoogleNetHttpTransport;
import com.google.api.client.http.HttpTransport;
import com.google.api.client.http.javanet.NetHttpTransport;
import com.google.api.client.json.JsonFactory;
import com.google.api.client.json.jackson2.JacksonFactory;
import com.google.api.client.util.Base64;
import com.google.api.services.gmail.Gmail;
import com.google.api.services.gmail.GmailScopes;
import com.google.api.services.gmail.model.Message;