34,597
社区成员
发帖
与我相关
我的任务
分享
declare @id int
select @id=id from (select top 1 id from tb order by id) m
print @id
declare @a table (id int,col varchar(1))
insert into @a
select 1,'a' union all
select 2,'b' union all
select 3,'c' union all
select 4,'d' union all
select 5,'e'
select * from @a
declare @result int
;with demp as
(
select row_number() over (order by id) as row,* from @a
)
select @result=id from demp where row=1
select @result 'result'
/*
id col
----------- ----
1 a
2 b
3 c
4 d
5 e
result
-----------
1
*/
DataTable dt = new DataTable();
//把存储过程的表给dt
dt.Rows[0][0].ToString();
--?
SELECT TOP 1 COL1 FROM TB ORDER BY ID