摘要:
1.查询某个表被哪些存储过程(以下简称 SP)使用 : select distinct object_name(id) fromsyscomments where id in (select object_id from sys.objects where type='P') and text li 阅读全文
摘要:
1、创建定时向表中插入数据的存储过程,名为testJob。 CREATE OR REPLACE PROCEDURE "testJob" AS BEGIN EXECUTE IMMEDIATE 'INSERT INTO TABLE_HIS SELECT * FROM TABLE_AI'; COMMIT; 阅读全文