-- SQL Code to illustrate excellent, venn diagram, teaching aid-- on SQL join types https://i.stack.imgur.com/UI25E.jpg CREATE TABLE #Dude ( DudeID INTEGER , DudeName VARCHAR(20) , JobID INTEGER ) CREATE TABLE #Jobs ( JobID INTEGER...
SELECT F.name , PT.name AS FromTab , PC.name AS FromCol , CT.name AS ToTab , CC.name AS ToColFROM sys.foreign_keys FINNER JOIN...
SELECT T.name AS TableName , C.colorder AS ColOrder , C.name AS ColName , CASE WHEN C.xtype = 34 THEN 'IMAGE' WHEN C.xtype = 35 THEN 'TEXT' WHEN C.xtype = 36 THEN 'UNIQUEIDENTIFIER' WHEN C.xtype =...
Original Article Shortcut keyDescription ALT+PAGE UPSwitches between programs from left to right. ALT+PAGE DOWNSwitches between programs from right to left. ALT+INSERTCycles through the programs in the order they were started. ALT+HOMEDisplays th...