problem with sql statement (serial number)

fgtr1230

I want to implement such a function:
select serial number =-I want to add one automatically here
       Alarm time = moment of acceptance
from TTask
where generate task moment> = @ BeginTime

I hope everyone can show it. Help

wgfxman

wgfxman

select serial number = (select ISNULL (MAX (serial number), 0) +1 FROM TTask)
       Alarm time = time to start acceptance
from TTask
where Generate task moment> = @ BeginTime

(select ISNULL (MAX (serial number), 0) +1 FROM TTask) can also be implemented with a custom function

我是杀人狂

select serial number = idenity (int, 1,1),
       Alarm time = time to start acceptance
into #a
from TTask
where Generate task moment> = @ BeginTime

kittast

select serial number = identity (int, 1,1),
       Alarm time = time to start acceptance
into #t
from TTask
where Generate task moment> = @ BeginTime

select * from #t

fgtr1230

The final table structure is like this:
1 2016-12-11
2 2016-12-12
3 2016-12-13

There is no serial number in my TTask table

fgtr1230

Ok thank you all

fanfan1980

--If there are no duplicate records, you can do this
create table T (col datetime)
insert T select '2016-12-11'
insert T select '2016-12-13'
insert T select '2016-12-12'

select ID = (select count (*) from T where col <= A.col), A. * from T as A
order by col

--result
ID col
----------- --------------------------------------- ---------------
1 2016-12-11 00: 00: 00.000
2 2016-12-12 00: 00: 00.000
3 2016-12-13 00: 00: 00.000

(3 row (s) affected)

liuzhaoge

select row_number () over (order by column) id, * from dbo.tableA

sql2015 can add row_number