随笔分类 -  数据库技术

摘要：存储过程分页大都会用到这样的语句SELECT *,row_number() OVER(ORDER BY id DESC) AS rowNumber FROM但是SQL2000 中不支持row_number() 需要使用 select ....into 配合临时表和IDENTITY (data_type [ , seed , increment ] ) AS column_name 来作为替代方案。... 阅读全文

摘要：以前拼接的写法set @sql='select * from table where 1=1 'if (@addDate is not null)set @sql = @sql+' and addDate = '+ @addDate + ' 'if(@name <>'' and is not null)set @sql = @sql+ ' and name = ' + @name + ... 阅读全文