Listest的博客

1、MSSQL Server 1 2 selectcount(*)fromdbo.sysobjectswherename='表名'；-- 表 selectcount(*)fromsyscolumnswhereid=object_id(‘表名’)andname='字段名'；-- 字段　 2、Oracle 1 2 selectcount(*)from...

CREATE procedure cp_sysconfig_dh_php /* 参数：@guid_dll 单号类型；@machinecode 机器号，非POS赋值为''； 返回值：@outdh 生成的单号 调用：需要生成单号的模块和存储过程 .

sql 代码如下： GO CREATE VIEW vcgbillddList as SELECT acode,provider, aguid AS guid_m, CONVERT(VARCHAR(10),date_yw,120) date_yw, ywname AS ywaname, addr, qty, bj, js, checkname,remark, CASE WHEN status&2>=2 THEN 2 ELSE 1 END AS st

SELECT B.guid_m,LEFT(kh_ddcodeList,LEN(kh_ddcodeList)-1) as kh_ddcodeDetail FROM ( SELECT guid_m, (SELECT kh_ddcode+', ' FROM xsbillfh_d WHERE guid_m=A.guid_m AND ISNULL(kh_ddcode,'')<>'' FOR XML PATH('')) AS kh_ddcodeList FROM xsbillfh_d A WH..

不解释直接上代码 alter PROCEDURE dbo.CP_OpenPiece_Sync @ID VARCHAR(36), @Code VARCHAR(150), @DatTim VARCHAR(150), @RecipeCode VARCHAR(50), @Customer VARCHAR(250), @ProjName VARCHAR(250), @ConsPos VARCHAR(250), @Mark VARCHAR(250), @proj_id INT , @topicTitle VARCH

直接上代码，关键替换@server ，@datasrc，@rmtpassword 对应的值。 USE [master] GO /****** Object: LinkedServer [jb90] Script Date: 2021-11-15 16:07:03 ******/ EXEC master.dbo.sp_addlinkedserver @server = N'jb90', @srvproduct=N'', @provider=N'SQLNCLI', @datasrc=N'ip,p.

1.话不多说，我喜欢case when .思路清晰易懂 SELECT PID,qty,qtyFinish,processesName FROM dbo.processesDetail SELECT PID, SUM(CASE processesName WHEN '激光' THEN qtyFinish ELSE 0 END) AS jgQty, SUM(CASE processesName WHEN '其他' THEN qtyFinish ELSE 0 END) AS qtQty,

1.不讲解，直接上代码 USE [shkj] GO /****** Object: Trigger [dbo].[processesDetail_update] Script Date: 11/14/2021 22:52:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --更新产品完成数 ALTER TRIGGER [dbo].[processesDetail_update] ON [dbo].[processesDetai

不说语法，直接看代码 USE [shkj] GO /****** Object: Trigger [dbo].[laserPrdTaskDetail_update] Script Date: 11/14/2021 21:51:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --更新激光任务单状态 alter TRIGGER [dbo].[laserPrdTaskDetail_update] ON [dbo].[laserPr