小荣博客

可以将null转换为0, 然后再加1。 例如: select isnull(col_num,0)+1 from t1;

sql触发器修改和新增 USE [AIS20181205143743] GO /****** Object: Trigger [dbo].[ICStockBill_INSERUpdate] Script Date: 2018-12-26 16:21:03 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO – =========...