- 博客(3)
- 收藏
- 关注
转载 sqlserver数据库异步处理的存储过程
CREATE Procedure AsynchronousInvoking @EXECSQL nvarchar(4000)AS BEGIN TRANSACTION DECLARE @JobID BINARY(16) DECLARE @ReturnCode INT SELECT @ReturnCode = 0 BEGIN EXECUT
2007-09-21 15:16:00 3063
原创 oracle定时任务配置
create or replace procedure P_testisbegindbms_output.put_line(这是系统测试);end P_test;declare jobno number;begin dbms_job.submit(jobno,P_test;,trunc(last_day(sysdate)+1),trunc(last_day(add_months(
2007-06-27 11:46:00 591
原创 设置oracle主键ID的触发器
DROP SEQUENCE SEQ1CREATE SEQUENCE SEQ1INCREMENT BY 1START WITH 1MAXVALUE 999999999999;DROP TRIGGER SET_IDCREATE OR REPLACE TRIGGER SET_ID BEFORE INSERT ON table FOR EACH ROWDECLARE ID number;B
2007-06-27 11:35:00 574
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人