SQL: create procedure dbo.TransferData_Web astruncate table lot_webinsert into lot_web select * from lottruncate table lotdetail_webinsert into lotdetail_web select * from lotdetailtruncate table lotnotice_webinsert into lotnotice_web select * from lotnoticetruncate table pustatus_webinsert into pustatus_web select * from pustatustruncate table pulimitcheck_webinsert into pulimitcheck_web select * from pulimitcheck GO .Net:DBAccessObject objDBAccessObject = new DBAccessObject(SystemUtil.GetSqlConnection()); objDBAccessObject.AddDBCommand(86400,"exec transferdata_web",System.Data.CommandType.Text); objDBAccessObject.ExecuteNonQueryCommand(); objDBAccessObject.ClearDBCommands();
astruncate table lot_webinsert into lot_web select * from lottruncate table lotdetail_webinsert into lotdetail_web select * from lotdetailtruncate table lotnotice_webinsert into lotnotice_web select * from lotnoticetruncate table pustatus_webinsert into pustatus_web select * from pustatustruncate table pulimitcheck_webinsert into pulimitcheck_web select * from pulimitcheck
GO
.Net:DBAccessObject objDBAccessObject = new DBAccessObject(SystemUtil.GetSqlConnection());
objDBAccessObject.AddDBCommand(86400,"exec transferdata_web",System.Data.CommandType.Text);
objDBAccessObject.ExecuteNonQueryCommand();
objDBAccessObject.ClearDBCommands();