摘要:
SELECT j.name AS Job_Name , h.step_id AS Step_Id , h.step_name AS Step_Name , h.message AS Message , h.run_date AS Run_Date , h.run_time AS Run_Time , 阅读全文
摘要:
public static bool DataGridViewToExcel(DataGridView dataGridView, bool isShowExcel) { int rowsQty = dataGridView.Rows.Count; int colsQty = dataGridVie 阅读全文
摘要:
public static bool ExportToExcel_dataSet(string queryNo, string conditions) { bool _bl = false; try { Docmd.cnnOpen(); SqlCommand cmd = new SqlCommand 阅读全文
摘要:
ALTER PROCEDURE dbo.sx_pro_AutoEmailContent AS Begin declare @Rqty int declare @n int declare @m_recipients varchar(1000) declare @m_copy_recipients v 阅读全文
摘要:
ALTER PROCEDURE dbo.sx_pro_autoEmail_account AS begin Declare @my_profile_name varchar(50) Declare @my_account_Name varchar(50) Declare @my_principal_ 阅读全文
摘要:
创建自动执行存储过程: 1.创建参数 2.删除已有同名的作业 3. 创建作业 4.创建作业步骤 5.连接服务器 6.创建作业调度 7.启动作业 ALTER PROCEDURE dbo.sx_pro_AutoExecJobCreation AS Begin Declare @jobName varch 阅读全文