sql格式化工具
1.在线格式化工具:
https://www.qianbo.com.cn/Tool/Beautify/Sql-Formatter.html
2. 格式化后用@拼接
string sql = @"
SELECT rack.rackRow,rack.rackColumn,rack.rackLayer
FROM rack
LEFT JOIN TaskListON rack.rackColumn = TaskList.Unload_ColAND rack.rackRow = TaskList.Unload_LineAND rack.rackLayer = TaskList.Unload_Layer
LEFT JOIN TaskList0ON rack.rackColumn = TaskList0.Unload_ColAND rack.rackRow = TaskList0.Unload_LineAND rack.rackLayer = TaskList0.Unload_Layer
WHERE rack.used = 0 AND ((TaskList.Unload_Col IS NULLAND TaskList.Unload_Line IS NULLAND TaskList.Unload_Layer IS NULL) OR (TaskList.Excute = 1))AND (TaskList0.Unload_Col IS NULLAND TaskList0.Unload_Line IS NULLAND TaskList0.Unload_Layer IS NULL)
ORDER BY rack.rackRow, rack.rackLayer
LIMIT 1;