数据库小知识

SQL数据库的存储过程分页

select a.name ‘TableName’
from sys.tables a
inner join sys.columns b on a.object_id=b.object_id
where b.name=’ShippingNO’