你可以试试dm_os_enumerate_filesystem()
号车管所.
它将从SQL Server 2017开始运行.
机动车管理局接受两个参数:
SQL个
-- SQL Server 2017 onwards
SELECT file_or_directory_name
, level, is_directory, creation_time, size_in_bytes
FROM sys.dm_os_enumerate_filesystem
(
N'C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn'
, N'*.*'
);
Output个
file_or_directory_name |
level |
is_directory |
creation_time |
size_in_bytes |
batchparser.dll |
0 |
0 |
2022-10-08 10:33:18.0000000 |
190408 |
bcp.exe |
0 |
0 |
2022-10-08 10:33:36.0000000 |
141224 |
Resources |
0 |
1 |
2021-11-30 23:33:46.1047932 |
0 |
SQLCMD.EXE |
0 |
0 |
2023-05-26 17:18:40.0000000 |
276376 |
xmlrw.dll |
0 |
0 |
2019-09-24 19:27:18.0000000 |
347752 |
1033 |
1 |
1 |
2021-11-30 23:33:46.1053619 |
0 |
bcp.rll |
2 |
0 |
2022-10-08 10:33:16.0000000 |
30664 |
license_SQLCMD.txt |
2 |
0 |
2022-10-08 10:31:00.0000000 |
18102 |
SQLCMD.rll |
2 |
0 |
2022-10-08 10:33:18.0000000 |
42912 |