SQL 用DISTINCT 筛选、删除重复数据  drop table #temp_11 SELECT DISTINCT DevName as a ,DevModel as b,StockPrice as c,min(FID) as fid,min(DevTypeID) as DevTypeID,min(DevTypeName) as DevTypeNameinto #te

SQL 插入时如表为空时值为NULL    SELECT (max(FID),0)+1  FROM  tbUserPermission会报错，加个判断ISNULL(*,0)即可避免出错。   SELECT  ISNULL(max(FID),0)+1  FROM  tbUserPermission 用select方法插入记录（一条语句：求得主键最大值，同时判断表中是否存在此记录，

SELECT  --a.YnUse,(select case when (SELECT  isnull(b.FID,0) FROM  dbo.tbUserPermission b WHERE  a.MID = b.MenuID AND a.FID = b.MID AND a.FunID = b.FunID-- and b.UID = 44 and a.MID=904 )>0 then

SQL 用左补位方法进行排序(ORDER BY)select right ('00000'+YmMonth,5) as YmMonth ,* from dbo.tblVisaYM  order by right ('00000'+YmMonth,5) desc左补位，如碰到数码长度不同是无法正确排序，用转换进行排序。如下：order by CONVERT(decimal(12, 2

SQL查找非数字记录，碰到字符数字转换数字进行计算，经常出错，用此SQL查找出出错记录。 SELECT MortarVolume,PATINDEX('%[^0-9]%', MortarVolume),*  FROM   dbo.GroutListData where PATINDEX('%[^0-9]%', MortarVolume)>0 or PATINDEX('%.%', Mort

Begin--returns @temp table(tbMID varchar(100))    declare @temp table(tbMID int)    declare @i int    declare @j int    declare @splitsign varchar(10)    declare @ConID int    declare @S