SQL – I Learnt Today

Quick reference for different SQL Joins

source: Visual Representation of SQL Joins from codeproject.com

SQL to Generate C# Properties from SQL Table Columns

2016/07/15 Below SQL will generate C# properties for all columns in a table in SQL server. Notes: You will have to fix datatypes that are not interchangeable between SQL and C#. You will also have to polish property names if you follow a different naming convention for column names. The query below automatically renames someContinue reading “SQL to Generate C# Properties from SQL Table Columns”