insert-statement

Help creating an INSERT INTO statement

I am inserting rows into SQL Server 2005 from PowerShell. I need to add a WHERE NOT EXISTS clause to my code to stop inserting duplicates. I am testing the SQL code in SSMS and cannot get it to work. Where is the mistake in the following code? INSERT INTO dbo.PrptyValSrce (PrptySrceName, PrptyNameSrce, PrptyValSrce, PrptyTS) VAL...

Checkboxes Inserting Into MySql Database

Hi guys, I have a survey type form, and in a number of the questions, the user has the option to tick more than one box. I am storing these answers in a mysql database however at the moment, the database only stores the very last checkbox that is ticked. Is there anyway to store all the checked values, possible separated by a coma, o...