SQL SERVER 查询语句
2019-12-05 本文已影响0人
one_8274
查询所有表
SELECT NAME FROM sysobjects WHERE xtype='U'
查询所有视图
SELECT NAME FROM sysobjects WHERE xtype='V'
分页查询
total_amount = 1000
page = 1
SELECT top 1000 * FROM table_name WHERE sqlid NOT IN (SELECT top ((1-1)*1000) sqlid FROM table_name
