sql-server - % 在 MS SQL Server 中是什么意思

Question

CASE WHEN INV_STOCK_TACKING_HEADER.STK_TACKING_STATUS != 2
                     THEN LTRIM(RTRIM(CONVERT(NVARCHAR(50), CONVERT(INT, ( ISNULL(STK_QTY,
                                                              0)
                                                              / ISNULL(dbo.VW_ITEM_UNITS_STK.BIG_TO_BASE_FACTOR,
                                                              0) ))))) + ' / '
                          + CONVERT(NVARCHAR(50), CONVERT(DECIMAL(18, 3), ISNULL(STK_QTY,
                                                              0))
                          % CONVERT(DECIMAL(18, 3), ISNULL(dbo.VW_ITEM_UNITS_STK.BIG_TO_BASE_FACTOR,
                                                           0)))
                     ELSE LTRIM(RTRIM(CONVERT(NVARCHAR(50), CONVERT(INT, ( ISNULL(dbo.INV_STOCK_TACKING_DETAILS.CURRENT_QTY,
                                                              0)
                                                              / ISNULL(dbo.VW_ITEM_UNITS_STK.BIG_TO_BASE_FACTOR,
                                                              0) ))))) + ' / '
                          + CONVERT(NVARCHAR(50), CONVERT(DECIMAL(18, 3), ISNULL(dbo.INV_STOCK_TACKING_DETAILS.CURRENT_QTY,
                                                              0))
                          % CONVERT(DECIMAL(18, 3), ISNULL(dbo.VW_ITEM_UNITS_STK.BIG_TO_BASE_FACTOR,
                                                           0)))
                END AS SYSTEM_QTY_EN ,

标签： sql-servertsql

Answer 1

%（模数）将左手操作数除以右手操作数并返回除法的整数余数。例如，5 % 3将给出2，因为5除以的余数3是2

select 5%3

result : 2