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 vcgbillddListasSELECT 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_ddcodeListFROM 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.processesDetailSELECT 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 ONGOSET QUOTED_IDENTIFIER ONGO--更新产品完成数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 ONGOSET QUOTED_IDENTIFIER ONGO--更新激光任务单状态alter TRIGGER [dbo].[laserPrdTaskDetail_update] ON [dbo].[laserPr