Question

select * from docrecord where doctype=#value# order by lastmodify desc limit 0,1

这是musql的语法，把他换成sqlserver支持的语法

Answer 1

select top 1 * from docrecord where doctype=#value# order by lastmodify desc