SelectCONVERT(varchar(100),GETDATE(),0):0516200610:57AM SelectCONVERT(varchar(100),GETDATE(),1):05/16/06 SelectCONVERT(varchar(100),GETDATE(),2):06.05.16 SelectCONVERT(varchar(100),GETDATE(),3):16/05/06 SelectCONVERT(varchar(100),GETDATE(),4):16.05.06 SelectCONVERT(varchar(100),GETDATE(),5):16...
ROW_NUMBER()over(orderbyGETDATE())asXh, SELECTFROM( SELECTsEmployeeNo,ROW_NUMBER()over(partitionbydbo.GetNoFromStr(sEmployeeNo) orderbydbo.GetNoFromStr(sEmployeeNo))asRowIndex, dbo.GetNoFromStr(sEmployeeNo)aa,sEmployeeNameCNFROMhrEmployee GROUPBYsEmployeeNo,sEmployeeNameCN )aWHERERowIndex>1
SELECTOBJECT_NAME(a.parent_obj)AS[表名], a.nameAS[触发器名称], (CASEWHENb.is_disabled=0THEN'启用' ELSE'禁用' END)AS[状态], b.create_dateAS[创建日期], b.modify_dateAS[修改日期], c.textAS[触发器语句] FROMsysobjectsa INNERJOINsys.triggersbONb.object_id=a.id INNERJOINsyscommentscONc.id=a.id WHEREa.xtype='tr' ORDERBY[表名]
ALTERTABLETmpADDIDXHintidentity(1,1) DECLARE@sNewNoteNoVARCHAR(50) EXECdbo.sppbGenerateNoteNoN'ML01',N'',1,@sNewNoteNoOUTPUT SELECT@sNewNoteNo DECLARE@iidINT SELECT@iid=NEXTVALUEFORsq_mmMaterialMst SELECT@iid DECLARE@iINT,@jINT,@cmone NVARCHAR(50) SELECT @i=min(xh) ,@j=MAX(xh)FR...
尺码打横 SELECTCangKuMC,BianMa,MingCheng,YanSeTM,YanSeMC,ShuLiang,ChiMaMC,LingShouJ,zhuGongYS intoxiaoshoud1 FROM[dbo].[v_QiMo_KuCunSP_XiMu]where1=1 DECLARE@sqlvarchar(4000) SET@sql='selectzhuGongYS,CangKuMC,BianMa款号,MingCheng名称,YanSeTM颜色代号,YanSeMC颜色' select@sql=@sql+',sum(caseChiMaMCwhen'''+ChiMaMC+'...
--插入触发器 ALTERTRIGGER[dbo].[Trg_into_fiPayableMoney] on[dbo].[fiPayableMoney] forinsert as BEGIN DECLARE@sCreatorVARCHAR(50),@uGUIDVARCHAR(50) SELECT@sCreator=dbo.GetEnumName('USER',sCreator),@uGUID=uGUIDFROMinserted; UPDATEfiPayableMoney SETsMoneyNo=sMoneyNo+'('+@sCreator+')'where@u...
IFOBJECT_ID(N'tempdb..tmpRFIDCardList')ISNOTNULLDROPTABLEtmpRFIDCardList; IFOBJECT_ID(N'tempdb..tmpPMWorkTeamDayQuotas')ISNOTNULLDROPTABLEtmpPMWorkTeamDayQuotas; IFOBJECT_ID(N'tempdb..tmppbManallocationDtl')ISNOTNULLDROPTABLEtmppbManallocationDtl; IFOBJECT_ID(N'tempdb..tmpRFIDOutput')ISNOTNULLDROPTA...
CREATEprocedure[dbo].[sp_who_lock] as begin declare@spidint,@blint, @intTransactionCountOnEntry int, @intRowcount int, @intCountProperties int, @intCounter int createtabletmp_lock_who( idintidenti...
ALTERPROCEDURE[dbo].[PRO_SuoDingkuCun_init] ( @sBillNo NVARCHAR(50)='' ) AS BEGIN BEGINTRY BEGINTRANSACTION --DECLARE@sBillNo NVARCHAR(50)='SMC230811005'--execPRO_SuoDingkuCun_init'SMC230811005' IFOBJECT_ID(N'tempdb..TEMP')ISNOTNULLDROPTABLETEMP;  ...