将目录下面所有的 代码 文件合并到一个 文件中，写著作权代码合并神器

将目录下面所有的 .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;