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.