摘要:
1、with as: WITH AS短语,可以称作为子查询部分(subquery factoring),可以定义一个SQL片断,该SQL片断会被整个SQL语句用到 例如:嵌套查询: select * from table1 where id in (select id from table1 whe 阅读全文
摘要:
CREATE PROC PAGE_DEMO @TABLENAME VARCHAR(20), @PAGESIZE INT, @PAGE INT AS DECLARE @NAMEPAGE INT, @RES VARCHAR(100) BEGIN SET @NAMEPAGE=@PAGESIZE*(@PAG 阅读全文