随笔分类 -  SQL Server

摘要:USE [SYCN]GO/****** Object: StoredProcedure [dbo].[udt_page] Script Date: 2017/10/13 17:27:37 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO alt 阅读全文
posted @ 2017-10-16 11:33 萌橙 阅读(182) 评论(0) 推荐(0)
摘要:select train_code,count(1) from tb_ask_trainbodyroadtrain group by train_code having count(1) >1 阅读全文
posted @ 2017-05-09 16:39 萌橙 阅读(187) 评论(0) 推荐(0)
摘要:create or replace trigger tr_tb_if_archivesafter inserton tb_if_archivesfor each rowdeclarepragma autonomous_transaction;beginPro_fdn_costuser(:new.BZ 阅读全文
posted @ 2017-05-03 16:49 萌橙 阅读(1107) 评论(0) 推荐(0)