sqlcmd -S .\sql2014 -d mmkj02 -E -Q "SET NOCOUNT ON;SELECT   '-- =============================================' + CHAR(13)+CHAR(10) +  '-- 存儲過程: ' + o.name + CHAR(13)+CHAR(10) +  '-- =============================================' + CHAR(13)+CHAR(10) +  'GO' + CHAR(13)+CHAR(10) +  ISNULL(REPLACE(m.definition, CHAR(10), CHAR(13)+CHAR(10)), '-- 內(nèi)置系統(tǒng)存儲過程，無T-SQL定義') + CHAR(13)+CHAR(10) +  'GO' + CHAR(13)+CHAR(10) FROM sys.objects o LEFT JOIN sys.sql_modules m ON o.object_id = m.object_id WHERE o.type = 'P' AND o.is_ms_shipped = 1 ORDER BY o.name;" -o "C:\sys_procs.sql" -y 0

如何導(dǎo)出系統(tǒng)存儲過程