摘要:
1.row_number 先来点数据,先建个表 SET NOCOUNT ON CREATE TABLE Person( FirstName VARCHAR(10), Age INT, Gender CHAR(1)) INSERT INTO Person VALUES ('Ted',23,'M') INSERT INTO Person VALUES ('John',40,'M') INSE... 阅读全文
摘要:
1.row_number 先来点数据,先建个表 SET NOCOUNT ON CREATE TABLE Person( FirstName VARCHAR(10), Age INT, Gender CHAR(1)) INSERT INTO Person VALUES ('Ted',23,'M') INSERT INTO Person VALUES ('John',40,'M') INSE... 阅读全文
|