How to change the value of a column after a specific time interval in sql server Database

Hello Experts, I have created a table using the following Query in the Sql server data base Named with (Appointment-20160925160528) for Doctor Appointment schedule

USE [aspnet-Appointment-20160925160528]
GO

/****** Object: Table [dbo].[doctorschedule1]   ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[doctorschedule1](

[id] [int] NULL,
[date] [nchar](10) NULL,
[8:00Am] [nchar](10) NULL,
[8:15Am] [nchar](10) NULL,
[8:30Am] [nchar](10) NULL,
[8:45Am] [nchar](10) NULL,
[9:00Am] [nchar](10) NULL
) ON [PRIMARY]

GO

There are Five Column named with | 8:00AM | 8:15AM | 8:30AM | 8:45AM | 9:00AM |
AND the value of the column are … Booked   Available  Available  Booked Available

After creating the table the table look like this:

8:00 AM8:15 AM   8:30 AM    8:45AM 8:00 AM
BookedAvailableAvailableBookedAvailable

Now i want to change the value of the column 8:00AM from Booked to Available if the current time of the system is 7 hours 44 minutes and 59 seconds 7:44:59 AM

How i can do this for each column in the database table .i am very new to sql server databases .any working example will be very helpful for me and bundle of thanks for your great time <3.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.