摘要:ALTER PROCEDURE pr_getQuerDianxin @flag INT=0, @dianxingList VARCHAR(200)=NULL, @splitChar VARCHAR(5)=' ' AS if @flag=1 begin SELECT INTO shclist from
阅读全文
03 2016 档案
摘要:ALTER PROCEDURE pr_getQuerDianxin @flag INT=0, @dianxingList VARCHAR(200)=NULL, @splitChar VARCHAR(5)=' ' AS if @flag=1 begin SELECT INTO shclist from
阅读全文
摘要:Control.CheckForIllegalCrossThreadCalls = false; DevExpress.Data.CurrencyDataController.DisableThreadingProblemsDetection = true;
阅读全文
摘要:禁用: ALTER TABLE trig_example DISABLE TRIGGER trig1 GO 恢复: ALTER TABLE trig_example ENABLE TRIGGER trig1 GO 禁用某个表上的所有触发器 ALTER TABLE 你的表 DISABLE TRIGGE
阅读全文
摘要:USE [jiFen ] GO / Object: Trigger [dbo].[trigger_EmpInfo] Script Date: 03/21/2016 17:26:24 / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO 触发器 ALTE
阅读全文
摘要:SELECT ,ROW_NUMBER() OVER(PARTITION BY bc ORDER BY CONVERT(int,firstOrder) ASC) AS num FROM temp
阅读全文
|