SQL Query return a value if running more than x seconds?

Question

Is it possible to terminate an executing query and return a specific value (e.g return value = 1 ) if a SQL query runs for longer than X seconds?

Could you please give a concrete example with a basic query. For example in SQL:

select * from test

If this query is taking more than 10 seconds to execute, it should return: 1 as the result.

I am using SQL management studio.

@a_horse_with_no_name :- Can you check pls my ans is valid or not?? — Darshak, Feb 08 '17 at 09:02

score 0 · Answer 1 · edited May 23 '17 at 10:29

0

Yes it,s possible. You can use Threading

Look here some examples

Can We use threading in PL/SQL?

edited May 23 '17 at 10:29

Community

1
1

answered Feb 01 '17 at 10:33

Kamil Ibadov

1,436
2
20
44

Alexandre Nascimento · Answer 2 · 2017-02-01T11:00:15.717

0

You can use DBPROP COMMANDTIMEOUT to specify the timeout and use a TRY CATH on your client because, in SQL, the connection timeout can not be recovered.

edited Feb 01 '17 at 11:00

answered Feb 01 '17 at 10:39

Alexandre Nascimento

183
1
5
20

For which DBMS does your answer apply? – Feb 01 '17 at 11:55
Apply for SQL SERVER – Alexandre Nascimento Feb 01 '17 at 11:56

Darshak · Answer 3 · 2017-02-08T06:03:29.680

0

I hope this will work for you.. i have put custom logic for that..

declare @Starttime datetime=getdate()


select * into #tmp from test


if DATEDIFF(SECOND,@Starttime,getdate()) >10
begin
   select 1
end

edited Feb 08 '17 at 06:03

answered Feb 08 '17 at 05:58

Darshak

859
7
18

SQL Query return a value if running more than x seconds?

3 Answers3