将目录下面所有的 .cs 文件合并到一个 code.cs 文件中,写著作权复制代码时的必备良药
@echo off
echo 将该目录下所有.cs文件的内容合并到一个 code.cs 文件中!
pause
dir /ad/s/b > folderPath.txt
md codeTemp
for /f "tokens=1* delims=:" %%i in ('type folderPath.txt^|findstr /n ".*"') do (copy %%j\*.cs codeTemp\%%i.cs )
copy codeTemp\*.* code.cs
rd /s/q codeTemp
del folderPath.txt
pause
本文来自博客园,作者:VipSoft 转载请注明原文链接:https://www.cnblogs.com/vipsoft/p/4190012.html
导出表结构为表格
SELECT
ROW_NUMBER() OVER(ORDER BY COLUMN_NAME) AS [序号],
COLUMN_NAME AS [列名],
DATA_TYPE AS [数据类型],
COALESCE(CHARACTER_MAXIMUM_LENGTH, 0) AS [长度],
CASE WHEN COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1 THEN '√' ELSE '' END AS [自增],
CASE WHEN IS_NULLABLE = 'YES' THEN '√' ELSE '' END AS [允许空],
COLUMN_DEFAULT AS [默认值],
'' AS [列说明]
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'bs_customersms' -- 替换为实际的表名
ORDER BY 序号, ORDINAL_POSITION;