Otdfbt

King or Queen-Which piece is which?

How to prevent cables getting intertwined

How "fast" do astronomical events occur?

Print the new site header

Digital signature that is only verifiable by one specific person

What is the precise meaning of "подсел на мак"?

Why swap space doesn't get filesystem check at boot time?

Why was New Asgard established at this place?

How to address players struggling with simple controls?

Is a sequel allowed to start before the end of the first book?

Why "amatus est" instead of "*amavitur"

Co-worker is now managing my team. Does this mean that I'm being demoted?

How can I ping multiple IP addresses at the same time?

In windows systems, is renaming files functionally similar to deleting them?

In a Fish that is not a Fish

How do I become a better writer when I hate reading?

Do details of my undergraduate title matter?

I wish, I yearn, for an answer to this riddle

What is this airplane that sits in front of Barringer High School in Newark, NJ?

Fill the maze with a wall-following Snake until it gets stuck

How do credit card companies know what type of business I'm paying for?

Is there any possible way to get these hearts as Adult Link?

What kind of chart is this?

Operator currying: how to convert f[a,b][c,d] to a+c,b+d?

Count down from 0 to 5 seconds and repeat [closed]

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

2

1

What query can I use to trigger a count down from 0 to 5 seconds whenever executed? When I execute a query the output has to be 0 second to 5 second and once 5 seconds are done again it should go back to 0. When I execute again it should start from 0 to 5 seconds. Is it possible to achieve something like this using sql query?

sql-server

share|improve this question

asked May 31 at 14:37

svisveshsvisvesh

192

closed as unclear what you're asking by marcello miorelli, Colin 't Hart, Andriy M, Marco, mustaccio Jun 3 at 14:36

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Can I just clarify, do you want to output a count after each second, or just simply wait for 5 seconds. You say the "output" has to be 0 to 5 seconds
  
  – George.Palacios
  May 31 at 14:44
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  It's unclear what you're actually hoping to achieve here. Certainly, you don't want to just show a countdown on the screen or waste CPU cycles. What are you going to do with this countdown? Other tools are probably more appropriate than a database for them.
  
  – jpmc26
  Jun 1 at 9:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  "Count down from 0 to 5"? Do you mean 0, 1, 2, 3, 4, 5 or 5, 4, 3, 2, 1, 0?
  
  – John Eisbrener
  Jun 3 at 13:26
  

  
  
  
  

add a comment | 

2

1

What query can I use to trigger a count down from 0 to 5 seconds whenever executed? When I execute a query the output has to be 0 second to 5 second and once 5 seconds are done again it should go back to 0. When I execute again it should start from 0 to 5 seconds. Is it possible to achieve something like this using sql query?

sql-server

share|improve this question

asked May 31 at 14:37

svisveshsvisvesh

192

closed as unclear what you're asking by marcello miorelli, Colin 't Hart, Andriy M, Marco, mustaccio Jun 3 at 14:36

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Can I just clarify, do you want to output a count after each second, or just simply wait for 5 seconds. You say the "output" has to be 0 to 5 seconds
  
  – George.Palacios
  May 31 at 14:44
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  It's unclear what you're actually hoping to achieve here. Certainly, you don't want to just show a countdown on the screen or waste CPU cycles. What are you going to do with this countdown? Other tools are probably more appropriate than a database for them.
  
  – jpmc26
  Jun 1 at 9:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  "Count down from 0 to 5"? Do you mean 0, 1, 2, 3, 4, 5 or 5, 4, 3, 2, 1, 0?
  
  – John Eisbrener
  Jun 3 at 13:26
  

  
  
  
  

add a comment | 

What query can I use to trigger a count down from 0 to 5 seconds whenever executed? When I execute a query the output has to be 0 second to 5 second and once 5 seconds are done again it should go back to 0. When I execute again it should start from 0 to 5 seconds. Is it possible to achieve something like this using sql query?

sql-server

share|improve this question

asked May 31 at 14:37

svisveshsvisvesh

192

share|improve this question

asked May 31 at 14:37

svisveshsvisvesh

192

share|improve this question

asked May 31 at 14:37

svisveshsvisvesh

192

asked May 31 at 14:37

svisveshsvisvesh

192

asked May 31 at 14:37

svisveshsvisvesh

192

2 Answers
2

active

oldest

votes

7

WaitFor should help you accomplish this.

In your case we can simply pass a DELAY time as below

WAITFOR DELAY '00:00:05';

This will simply wait for 5 seconds, then return to the caller.

share|improve this answer

answered May 31 at 14:41

George.PalaciosGeorge.Palacios

3,219827

add a comment | 

6

Have you looked into the waitfor delay command? See below example

while 1=1
begin
 --do something
 waitfor delay '00:00:05'
end

share|improve this answer

answered May 31 at 14:40

kevinnwhatkevinnwhat

91319

add a comment | 

7

WaitFor should help you accomplish this.

In your case we can simply pass a DELAY time as below

WAITFOR DELAY '00:00:05';

This will simply wait for 5 seconds, then return to the caller.

share|improve this answer

answered May 31 at 14:41

George.PalaciosGeorge.Palacios

3,219827

add a comment | 

7

WaitFor should help you accomplish this.

In your case we can simply pass a DELAY time as below

WAITFOR DELAY '00:00:05';

This will simply wait for 5 seconds, then return to the caller.

share|improve this answer

answered May 31 at 14:41

George.PalaciosGeorge.Palacios

3,219827

add a comment | 

WaitFor should help you accomplish this.

In your case we can simply pass a DELAY time as below

WAITFOR DELAY '00:00:05';

This will simply wait for 5 seconds, then return to the caller.

share|improve this answer

answered May 31 at 14:41

George.PalaciosGeorge.Palacios

3,219827

WAITFOR DELAY '00:00:05';

share|improve this answer

answered May 31 at 14:41

George.PalaciosGeorge.Palacios

3,219827

answered May 31 at 14:41

George.PalaciosGeorge.Palacios

3,219827

answered May 31 at 14:41

George.PalaciosGeorge.Palacios

3,219827

6

Have you looked into the waitfor delay command? See below example

while 1=1
begin
 --do something
 waitfor delay '00:00:05'
end

share|improve this answer

answered May 31 at 14:40

kevinnwhatkevinnwhat

91319

add a comment | 

6

Have you looked into the waitfor delay command? See below example

while 1=1
begin
 --do something
 waitfor delay '00:00:05'
end

share|improve this answer

answered May 31 at 14:40

kevinnwhatkevinnwhat

91319

add a comment | 

Have you looked into the waitfor delay command? See below example

while 1=1
begin
 --do something
 waitfor delay '00:00:05'
end

share|improve this answer

answered May 31 at 14:40

kevinnwhatkevinnwhat

91319

while 1=1
begin
 --do something
 waitfor delay '00:00:05'
end

share|improve this answer

answered May 31 at 14:40

kevinnwhatkevinnwhat

91319

answered May 31 at 14:40

kevinnwhatkevinnwhat

91319

answered May 31 at 14:40

kevinnwhatkevinnwhat

91319