邻家小院- - SQL语句

开屏1.0 2.0批量替换店号SQL

admin — Thu, 02 Apr 2026 00:48:26 +0000

-- 1. 更新记录绑定表 UPDATE [lj_kp].[dbo].[记录绑定] SET 范围组ID = 115 WHERE 设备ID IN ( \'10948\',\'10272\',\'10935\',\'10339\',\'11303\',\'10410\',\'11365\',\'10569\',\'100322\',\'10110019\', \'10110016\',\'70725\',\'11166\',\'10832\',\'11076\',\'10963\',

SQL SERVER将已有的分组复制一份到新分组

admin — Mon, 09 Feb 2026 01:52:15 +0000

INSERT INTO [lj_dzsw].[dbo].[黑名单] (商品名, 分组, 修改时间) SELECT t.商品名, -- 引用外层别名t的商品名字段 \'淮南市烟草\', -- 分组替换为「淮南市烟草」 t.修改时间 -- 保留原修改时间 FROM [lj_dzsw].[dbo].[黑名单] AS t -- 外 ...

更新工号加09

admin — Wed, 21 Jan 2026 07:48:32 +0000

UPDATE LOTTERYREDEEM SET FIELD1 = storecode || \'09\' WHERE FIELD1 = \'09\';

SQL 2012

admin — Tue, 20 May 2025 15:14:32 +0000

USE Lj_AI; GO CREATE TABLE Lj_AI_Category ( CategoryID INT PRIMARY KEY IDENTITY(1,1), CategoryName NVARCHAR(100) NOT NULL UNIQUE, ParentCategoryID INT NULL, CreateTime DATETIME DEFAULT GETDATE(), Description NVARCHAR(500

orcale把重复的业务并且未处理的标记

admin — Fri, 16 May 2025 08:21:00 +0000

UPDATE LJBUSAMOUNT la SET la.STATE = \'作废状态\' WHERE la.STATE IS NULL AND EXISTS ( SELECT 1 FROM LJACCOUNT ac WHERE TRIM(la.STOREID) = TRIM(ac.ACCOUNTID) AND ac.ORGTYPE = 2 ) AND la.SETTLEDATE >= \'2025/05/05\' AND RO

H6贸易协议,到期前7天提醒

admin — Wed, 07 May 2025 03:35:41 +0000

SELECT a.BEGINDATE, a.ENDDATE, b.CODE, b.NAME, NVL(h.CTRBP2, \'\') AS CTRBP2 FROM ( SELECT v.*, ROW_NUMBER() OVER (PARTITION BY v.NUM ORDER BY v.ENDDATE DESC) AS rn FROM HD40.VDRAGMTDTLINV v W

供应商不足7天显示

admin — Mon, 05 May 2025 01:37:19 +0000

select CODE,NAME,CNTRBGNDATE,CNTRENDDATE,VDRSTAT,CONTACTOR,CTRBP2 from HD40.VENDORH t where VDRSTAT=\'已合作\' AND CNTRENDDATE - SYSDATE < 7 AND CNTRENDDATE >= SYSDATE

SQL SERVER2012 右连接

admin — Thu, 24 Apr 2025 06:27:20 +0000

SELECT s.[ID], s.[store], s.[store_name], s.[conn], s.[equipmentNo], s.[timestamp], s.[note], s.[region], c.[shopNo] FROM [lj_tc].[dbo].[STORE_TERM_STORE] s LEFT JOIN [lj_tc].[dbo].[STORE_TERM_CO

SQL Server 排它锁行锁

admin — Sun, 06 Apr 2025 11:35:29 +0000

集_连接池.开始事务 () 局_SQL ＝ “select * FROM ORDERS WITH (XLOCK, ROWLOCK) where order_id=\'123\'” 局_记录集.导入 (集_连接池.取记录集 (局_SQL, , )) 输出调试文本 (删首尾空 (局_记录集.读记录 (“order_id”).取文本 ())) 集_连接池.保存事务 () 局_记录 ...

ORCALE 增加字段可空默认为0

admin — Wed, 02 Apr 2025 02:59:10 +0000

ALTER TABLE HD40.LJ_PAYMENTMADE_new ADD ET NUMBER DEFAULT 0 NULL;

SQL添加唯一索引

admin — Sat, 15 Mar 2025 03:59:26 +0000

-- 添加唯一约束 ALTER TABLE LJACCOUNT_MD ADD CONSTRAINT uk_user_id_no UNIQUE (USER_ID_NO); -- 删除重复数据（保留一条）或查 DELETE FROM LJACCOUNT_MD WHERE ROWID NOT IN ( SELECT MIN(ROWID) FROM LJACCOUNT_MD GROUP BY USER_ID_NO HAVING ...

分页加排序

admin — Sun, 06 Oct 2024 01:00:30 +0000

select ROWNUM RN,KK.*from ( select PAY_ACCNO as 帐号, PAY_ACCNAME as 户名 , TRANS_AMT as 交易金额, CUR_AMT as 当前余额, decode(TRANS_TP, \'01\',\'转账入金\', \'02\',\'退汇\', \'03\',\'支付渠道入金\', \'04\',\'提现\', \'05\',\'退款-(预留)\', \'06\',\'其它\') ...

ORCALE备份表

admin — Tue, 30 Jul 2024 00:51:47 +0000

create table ljaccount_20230419 as select * from ljaccount

orcale文本连接符号

admin — Mon, 29 Jul 2024 02:42:10 +0000

select *from LJACCOUNT where storeid=\'80210073\'||\'B\' for update

oracle 查询某列有重复的值

admin — Fri, 26 Jul 2024 00:32:22 +0000

SELECT user_id, COUNT(*) FROM LJACCOUNT GROUP BY user_id HAVING COUNT(*) > 1; 查询 LJACCOUNT 中user_id 有重复的

SQL 嵌套查询

admin — Tue, 11 Jun 2024 09:42:45 +0000

SELECT *FROM LJACCOUNT where user_id= (select USER_ID from LJACCOUNT where storeid=\'11026B\' )

orcale取文本长度LENGTH

admin — Wed, 27 Mar 2024 00:30:32 +0000

select * from LOTTERYREDEEM WHERE FIELD4=\'修正\' and LENGTH(storecode)=8 for update

体彩兑奖修正未获取工号

admin — Mon, 25 Mar 2024 02:57:23 +0000

update LOTTERYREDEEM set FIELD4=\'修正\' FIELD1= to_char(TO_CHAR(storecode) || TO_CHAR(\'09\')) where FIELD3 IS NOT NULL AND FIELD1 IS NULL

orcale分页查询

admin — Tue, 12 Mar 2024 02:47:01 +0000

select *from ( select t.*,ROWNUM RN from LJACCOUNT t ) where RN between 19 and 21

oracle增加表字段

admin — Wed, 17 Jan 2024 00:29:40 +0000

alter Table LJACCOUNT add （TEMPGS varchar(40) default \'\'， MARKUP NUMBER(24,4) Default 0）