DanielLoth

--select text from Payroll.sys.syscomments where id = 55086;
select * from sys.sql_modules where [object_id] = 55086;

select value from STRING_SPLIT(
(select [definition] from Payroll.sys.sql_modules where [object_id] = 55086), char(10));

select value from STRING_SPLIT(
(select replace([definition], char(13), '') from Payroll.sys.sql_modules where [object_id] = 55086), char(10));

DanielLoth

with CommaSeparatedColNames as (
	select
		TABLE_NAME,
		DATA_TYPE,
		CHARACTER_MAXIMUM_LENGTH,
		NUMERIC_PRECISION,
		NUMERIC_SCALE,
		ListIdColName,
		ColNameList,
		TPrefixedColNameList,

DanielLoth

# Negotiating salary

https://www.reddit.com/r/personalfinance/comments/7psra0/reminder_never_tell_hr_how_much_you_make_or_are/

-----

Reddit user sadakxp (https://www.reddit.com/user/sadakxp) made this post:


Here's why this is not fair and what you should do about it, as a person interviewing.

DanielLoth

----------------------------------------------------------------------------------------------------
-- AUDITING WITH TRIGGERS
-- Written by Daniel Loth
----------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------
-- Populate a numbers table
--------------------------------------------------------------------------------
drop table if exists Number
go

DanielLoth

dotnet new mvc -o MyProject

cd MyProject

REM CodeGenerators.Mvc added as package
dotnet add package "Microsoft.VisualStudio.Web.CodeGeneration.Design"
dotnet add package "Microsoft.VisualStudio.Web.CodeGenerators.Mvc"

REM CodeGeneration.Tools added as reference (not package) as it is tooling.
dotnet add reference "Microsoft.VisualStudio.Web.CodeGeneration.Tools"

DanielLoth

GitHub repository

https://github.com/codesmithtools

Files of interest

All ****.zip files contain entire application templates.

This one actually creates SQL from the schema:

DanielLoth

-- Based on this article: http://modern-sql.com/use-case/pivot

set nocount on

declare @Table table (
	TableName char(20),
	AttributeName char(20),
	AttributeValue char(20),

	-- Mandatory: Each attribute must appear precisely once for each element.

DanielLoth

• https://en.wikipedia.org/wiki/ISO_3166-2
  • https://en.wikipedia.org/wiki/ISO_3166-2:AU
  • https://en.wikipedia.org/wiki/ISO_3166-2:NZ
• https://en.wikipedia.org/wiki/ISO_3166-1
  • https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2
  • https://en.wikipedia.org/wiki/ISO_3166-1_alpha-3
  • https://en.wikipedia.org/wiki/ISO_3166-1_numeric
• https://en.wikipedia.org/wiki/ISO_4217
• https://en.wikipedia.org/wiki/ISO_639

DanielLoth

-----BEGIN CERTIFICATE-----
N3q8ryccAARv0zvW0fUAAAAAAAAkAAAAAAAAAJ7EOroM7Zc0a6+nStey+OM7CfYN
jOFPik6bvYw80OCK9XtdvCpjNhqVOcmqH8nm3wSpBid2RCt/kOxnevEbrGAxe4oA
JOFnI+T2J25XphO9QATnd62Sassxl1ci57iiYMpVW3ef3/pFXUpFAqanMl65w6Ie
GKVyZZVr+Rk3esLMNfOKFo73yqUxflnGUfrI/fXRK0WbULgOGWTlIoIZ/4ahEbgP
cNmJNeRq+cXq43O6LXrOZsli2rQymuvO6nBS5uqgE/nFV3aiWMhZIiZUo64rDL2a
l1WYIHKAgI/02hDCOKyBhNIEHq2aRrtxBla/rOtYvmOxttVD1l4ZPYyowcg2AShc
kafOkU4dd5TTucc9dZpHqIRxCwvvhZ3kvmThakEn0LADSDr3B19Hnil2jsYtfkQ3
fq/ldPQJD/DxjGmolifwBlx3Wh5OVDq7u72bMmHOtHjchrc0AFo+0tDeXGH1q9rk
Amqe9bwRjf1fuptEzYqK6lTmEQCiEn+ao/XCqkgaIAvWhG5FFIElWb/tlve9azqN

DanielLoth

IF OBJECT_ID('tempdb.dbo.#tempdep', 'U') IS NOT NULL
  DROP TABLE #tempdep;

CREATE TABLE #tempdep (objid int NOT NULL, objname sysname NOT NULL, objschema sysname NULL, objdb sysname NOT NULL, objtype smallint NOT NULL)


exec sp_executesql N'
INSERT INTO #tempdep 
SELECT
tbl.object_id AS [ID],