AI.NET 极客圈

今天在查询数据的时候，突然要查指定IP范围内的IP总数，思考了一下，主要使用charindex和reverse，下面是详细的SQL语句 DECLARE @IP varchar(50), @IPSub varchar(40), @range varchar(10), @beginIP varchar(50), @endIP varchar(50), @max int, @min int, @

查询第30到第40之间的数据(3种方式) SELECT * FROM (SELECT *,row_number() over(order BY ID) as row_num from UserActivityLog) as tt WHERE row_num >30 AND row_num <=40 SELECT TOP 10 * FROM UserActivityLog WHERE ID N

select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' declare @spid int Set @spid = 83 --锁表进程 decla