Dalesjo

  <!--
  Format date nlog
  https://github.com/NLog/NLog/issues/1199
  http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169814.htm
  https://github.com/nlog/NLog/wiki/Date-Layout-Renderer
  
  -->
  
  
  <variable name="fmt" value="${longdate} | ${level} | ${logger} | ${day} | ${month} | ${message}"/>

Dalesjo

SELECT 
c.name AS ColName, 
t.name AS TableName
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%Trailer%';

Dalesjo

SELECT
	[parentTable].name AS parentTable,
	[childTable].name AS childTable,
	[constraint].name AS [constraint],
	[parentColumn].name AS parentColumn,
	[childColumn].name AS childColumn
FROM sys.foreign_key_columns as fk
INNER JOIN sys.objects AS [constraint] ON [constraint].[object_id]=[fk].constraint_object_id
INNER JOIN sys.objects AS [parentTable] ON [parentTable].[object_id]=[fk].[referenced_object_id]
INNER JOIN sys.columns as [parentColumn] ON [parentColumn].[column_id]=[fk].[referenced_column_id] AND [parentColumn].[object_id]=[fk].[referenced_object_id]

Dalesjo

#!/bin/bash

SMGUID=0
SMBGID=0

while getopts 'd:s:u:p:U:G:' flag; do
  case "${flag}" in
    d) DIRECTORY="${OPTARG}" ;;
    s) SHARE="${OPTARG}" ;;
    u) USERNAME="${OPTARG}" ;;