清山博客

摘要： -join的用法DECLARE @TA TABLE (IDA INT,VA VARCHAR(10))DECLARE@TB TABLE (IDB INT,VB VARCHAR(10))INSERT INTO @TA SELECT1,'AA' UNION SELECT2,'BC' UNION SELECT3,'CCC'INSERT INTO @TBSELECT 1,'2' UNION SELECT3,'58' UNION SELECT4,'67' --内联接简单写法SELECT A.IDA,A.VA,B 阅读全文

摘要： 【SQL SERVER 数据库实用SQL语句】 1.按姓氏笔画排序: Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as 2.分页SQL语句 select * from(select (row_number() OVER (ORDER BY tab.ID Desc)) as rownum,tab.* from 表名 As tab) As t where rownum between 起始位置 And 结束位置 3.获取当前数据库中的所有用户表 select * from sysobject 阅读全文