Watch Pre-recorded Live Shows Here
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Lukhanyiso Banzana
0
1
0
SQL 2008 database update
Jun 24 2009 6:16 AM
We have a table in a hotel management system, the table is called RoomAvailability, the fields are roomID int, roomDate DateTime, Available bit.... the roomDate field is populated with every single day of the year, as a client is booked the relevant days are supposed to be marked unavailable.... could some one please help us with the SQL statement to update this table because its been a long time now that we're stuck on this
Reply
Answers (
1
)
sqlbulkcopy
Create Variables and Properties from Database Table