愛晴狂想曲

SELECT obj.name TableName, ind.name IndexName, col.name IndexColumn, incol.index_column_id IndexColumnSN FROM sys.columns col INNER JOIN sys.objects obj ON obj.object_id = col.object_id INNER JOIN sys.index_columns incol ON incol.COLUMN_ID = col.column_id AND incol.object_id = obj.object_id INNER JOIN sys.indexes ind on ind.index_id = incol.index_id AND obj.object_id = ind.object_id WHERE obj.name = 'TableName' order by ind.name, incol.index_column_id

  System.Diagnostics.Process.Start(FilePath)

 LINQ 延遲執行 立即執行 Where及回傳值為IEnumerable<T>的語法, 都是延遲執行 其他的一些像First、Count、ToArray、ToList、ToDictionary、ToLookup都是立即執行 ref web: https://www.cnblogs.com/GreenLeaves/p/7601476.html

DateTime is a value type   ( struct ) This means that the following creates a copy: DateTime toBeClonedDateTime = DateTime.Now; DateTime cloned = toBeClonedDateTime; ref web: https://stackoverflow.com/questions/4265399/how-can-i-clone-a-datetime-object-in-c