如何使用脚本读取文件属性？

I need to write either a PowerShell or batch script to read the property of files in the folder on certain time schedule and store it in a SQL Table.I need to write either a PowerShell or batch sc