Can someone give me an example of how to insert an event into the calendar using SQL? I'm using PHP and the MSSQL connecter. I'm very familiar with how to do this using MySQL but MSSQL is proving more difficult.
SQL Insert into CalendarEvent table
Mar 09, 2007
3 Replies
I am not sure what you really wanted to insert. however the below query insert the data.
Thanks,
That is exactly what I was looking for. I have one follow-up question. It mostly looks like I just need to learn to use MS SQL better, but can you tell me how I would insert an arbitrary date into either of those fields. Like say I wanted the reminder to show up on
3/19/2007 at 4:00pm. Thanks for your help. It is much appreciated.HI Tiff, You can write the following query to accomplished this. INSERT INTO CalendarEvent (StoreID, CashierID, DateTime, Text, ReminderEnabled, ReminderDate, IsPersonal) VALUES (0, 1, '03/09/2007 4:00pm', 'Testing', 0, '03/09/2007 4:00pm', 0)
" snipped-for-privacy@gmail.com" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required