發表文章

目前顯示的是 2月, 2020的文章

mssql procedure try catch

BEGIN  BEGIN TRY         -- do someting  END TRY  BEGIN CATCH   --DB查詢用   SELECT ERROR_NUMBER() AS ErrorNumber,       ERROR_MESSAGE() AS ErrorMessage,       ERROR_LINE() AS ErrorLine,       ERROR_PROCEDURE() AS ErrorProcedure,       ERROR_SEVERITY() AS ErrorSeverity,       ERROR_STATE() AS ErrorState   --系統拋回訊息用   DECLARE @ErrorMessage As NVARCHAR(1000) = N'錯誤代碼:' +CAST(ERROR_NUMBER() AS VARCHAR) + ';'             +N'錯誤程序名稱:'+ ISNULL(ERROR_PROCEDURE(),'')+ ';'             +N'錯誤行號:'+ CAST(ERROR_LINE() AS VARCHAR)+ ';'             +N'錯誤訊息:'+ ERROR_MESSAGE()   DECLARE @ErrorSeverity As Numeric = ERROR_SEVERITY()   DECLARE @ErrorState As Numeric = ERROR_STATE()   RAISERROR( @ErrorMessage, @ErrorSeverity, @ErrorState);--回傳錯誤資訊  END CATCH END

執行須Admin權限的執行檔

轉寫一個BAT內容如下 runas /profile /savecred /user:Administrator "cmd /c C:\Program\program.exe " 執行後輸入一次密碼之後,後面使用就不需要再輸入密碼了。