I want to insert a value daily every after 3 minute in sql server 2012

Question

I want to insert a value daily every after 3 minute in asp.net C# For example: today's date is 1 sep 2020 My Insert Id is 01092020001 01092020002 01092020003 01092020004 " " " 01092020480. This Id is inserted after every 3 minutes. And changed after that every 12:00 A.M. o'clock Next day id is 02092020001

Laxmidhar Sahoo · Answer

"form1" runat= "server" > "ScriptManager1" runat= "server" > "UpdatePanel1" runat= "server" UpdateMode= "Conditional" ViewStateMode= "Enabled" > "Label1" runat= "server" Font-Size= "14pt" >AJAX in Action "Image1" runat= "server" ImageUrl= "~/img/Desert.jpg" Width= "200px" /> "Timer1" EventName= "Tick" /> "Timer1" runat= "server" Interval= "120000" OnTick= "Timer1_Tick" > //code int counter = 0; protected void Timer1_Tick( object sender, EventArgs e) { //here call insert statement counter++; if (counter == 480) increase your id } Thans and regards

Laxmidhar Sahoo · Answer

hi In timer tick event with interval 3 minutes call insert statement . Increment a counter increased by 1. when the counter value will be 480 then change the id . Because a hour has 20 innervals for 3 minutes interval time ,For 24 hours it will be 20x24 Thanks and regards

Sachin Rathore · Answer

Thanks sir your code is working. If I close my session website after that is it also workig automatically running.

Sachin Rathore · Answer

Sir please give me an explample of this type of question and how can i done with triger