找出SQL Server資料庫unicode欄位

找出SQL Server資料庫欄位內中有非英文的資料

Schema Zen - Script and create SQL Server objects quickly

https://github.com/sethreno/schemazen

D:\ExportSchema\SchemaZen.exe script --server 127.0.0.1 --database 資料庫名稱 --scriptDir D:\ExportSchema\

除了script參數以外，還有create和compare
script參數：generate sql scripts for all objects in the database
create參數：create a database named db from the sql scripts
compare參數：compare databases

sp_addextendedproperty、sp_updateextendedproperty、sp_dropextendedproperty(SQL Server物件的擴充屬性)

--新增註解
EXEC sp_addextendedproperty @name=N'使用者代碼', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MyTable', @level2type=N'COLUMN',@level2name=N'ACCOUNTID'


--更新註解
EXEC sp_updateextendedproperty @name=N'使用者代碼', @value=N'長度25' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MyTable', @level2type=N'COLUMN',@level2name=N'ACCOUNTID'

--刪除註解
EXEC sp_dropextendedproperty @name=N'使用者代碼', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MyTable', @level2type=N'COLUMN',@level2name=N'ACCOUNTID'


The Will Will Web | 如何編輯 SQL Server 中物件的擴充屬性(Extended Property)
https://blog.miniasp.com/post/2008/07/19/How-to-access-SQL-Server-Objects-Extended-Property.aspx

利用forfiles指令刪除7天前的檔案和資料夾

forfiles /P D:\ExportData\ /S /M *.* /D -7 /C "cmd /c del @PATH"
forfiles /p D:\ExportData\ /D -7 /C "cmd /c IF @isdir == TRUE rd /S /Q @path"