摘要：忽然就有这种问题了，查找的时候找不到，针对别的数据库可以，就那俩个不行，查看日志上面写的是 20 Oct 2017 14:13:38.136 [56] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: ‘*********** 阅读全文

摘要：获取分组后取某字段最大一条记录 方法一：(效率最高) select * from test as a where typeindex = (select max(b.typeindex) from test as b where a.type = b.type ); 阅读全文

摘要：SELECT Left(Cast(Cast(1000000 * Rand(Cast(NewId() as binary(16))) as int) as nvarchar) + '000000', 6) 阅读全文

摘要：SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE XXX @userId INT AS BEGIN IF @userId IS NULL RETURN 0 BEGIN TRY BEGIN TRAN -----------------------------... 阅读全文

摘要：SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE Proc [g].[ListXXX] @pageNo int = 1, @pageSize int = 10 As Begin Declare @pageEnd int Declare @pageStart int Set @pa... 阅读全文