兰博丶专属

摘要： --当天： select * from T_news where datediff(day,addtime,getdate())=0 --最近三天： select * from T_news where datediff(day,addtime,getdate())= 0 --本周： select * from T_news WHERE (DATEPART(wk, addtime) =... 阅读全文

摘要： ROW_NUMBER() OVER (ORDER BY (select Null)) AS Id entity framework 查询中有这句会有异常 阅读全文

摘要： DECLARE @UserID INT; --推广员帐号 DECLARE @ProxyID INT; --代理帐号 DECLARE @Score INT=1000; --分数 SELECT @UserID = [SpreaderID] FROM [QPAccountsDB].[dbo].[AccountsInfo] WHERE UserID = 5055; SELECT ... 阅读全文

摘要： with cte as ( select belongsAgent from [QPProxyDB].[dbo].[BS_ProxyInfo] where ProxyID = @ProxyID union all select a.ProxyID from [QPProxyDB].[dbo].[BS_ProxyInfo] a join cte b on a.ProxyID = b.belong... 阅读全文

摘要： USE [QPTreasureDB] GO /****** Object: StoredProcedure [dbo].[GameStatistics] Script Date: 2018/8/16 10:33:10 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[GameStatistics]... 阅读全文

摘要： CREATE LOGIN [计算机名\Windows帐户名] FROM WINDOWS 阅读全文

摘要： --将text替换成你要查找的内容 SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%AgentRoomCardOrder%' AND ROUTINE_TYPE='PROCEDURE' 阅读全文

摘要： public class Net { [DllImport("wininet")] private extern static bool InternetGetConnectedState(out int connectionDescription, int reservedValue); /// 阅读全文

摘要： public partial class Form1 : Form { #region u盘属性 public const int WM_DEVICECHANGE = 0x219;//U盘插入后，OS的底层会自动检测到，然后向应用程序发送“硬件设备状态改变“的消息 public const int DBT_DEVICEARRIVAL... 阅读全文

摘要： public class Log { private ILog logger; public Log(ILog log) { this.logger = log; } public void Debug(object message) { thi... 阅读全文