----表
CREATE TABLE TESTTABLE
(
testID int identity primary key not null,
testParentid varchar(20),
testName varchar(20),
testValues varchar(20),
testNotes varchar(20)
)
INSERT INTO TESTTABLE VALUES('0','A','01','')
INSERT INTO TESTTABLE VALUES('0','B','02','')
INSERT INTO TESTTABLE VALUES('1','C','03','')
INSERT INTO TESTTABLE VALUES('2','D','04','')用存储过程实现去SELECT * FROM TESTTABLE中第三条数据?这个存储过程该这么去写了,留点意见了?
CREATE TABLE TESTTABLE
(
testID int identity primary key not null,
testParentid varchar(20),
testName varchar(20),
testValues varchar(20),
testNotes varchar(20)
)
INSERT INTO TESTTABLE VALUES('0','A','01','')
INSERT INTO TESTTABLE VALUES('0','B','02','')
INSERT INTO TESTTABLE VALUES('1','C','03','')
INSERT INTO TESTTABLE VALUES('2','D','04','')用存储过程实现去SELECT * FROM TESTTABLE中第三条数据?这个存储过程该这么去写了,留点意见了?
as
begin
select * from TESTTABLE where testID=3
end
goexec prc
as
begin
select * from (select top 3 * from testtable) a where a.testid not in
( select top 2 testid from testtable)end
goexec prc