Rex IT Blog

https://msdn.microsoft.com/zh-tw/library/ms176061(v=sql.120).aspx

--建立Stored procedure CREATE PROCEDURE [dbo].[mysp_truncate]  @tableName varchar(50) with execute as owner AS DECLARE @SQL VARCHAR(2000)...

sqlcmd -S 資料庫位址 -d 資料庫名稱 -i CUSTOMERS.sql > log\CUSTOMERS.log ref: https://msdn.microsoft.com/zh-tw/library/ms180944(v=sql.120).aspx ...

select * from sys.tables where type = 'V'

select * from sys.tables where type = 'U'

http://stackoverflow.com/ questions/606234/select-count- from-multiple-tables   橫的 with t1_count as ( select count (*) c1 from t1...

https://chocolatey.org