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_numfrom UserActivityLog) as ttWHERE row_num >30 AND row_num <=40SELECT 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