随笔分类 -  sqlserver

摘要：select top 1800 * from AJ_AQJDSBwhere id >(select max(id) from (select top 2000 id from AJ_AQJDSB order by id) b)select top 1800 * from AJ_gcxx where id not in (select top 2000 id from AJ_gcxx orde... 阅读全文

摘要：stuff(@temp,1,3,@temp2)切忌 第二个参数不能为0如果为0将返回null 阅读全文

摘要：SELECT 表名=case when a.colorder=1 then d.name else '' end, 表说明=case when a.colorder=1 then isnull(f.value,'') else '' end, 字段序号=a.colorder, 字段名=a.name, 标识=case when COLUMNPROPERTY( a.id,a.name,'Is... 阅读全文

摘要：declare @tableName varchar(50)declare @pageIndex intdeclare @pageSize intset @pageIndex = 3set @pageSize = 20declare @tempTable table(ID int Identity,ajid varchar(50))declare @maxCount intset @maxCoun... 阅读全文