[Resolved] insert statement in mssql

[terfle]

$sql = "INSERT INTO table SET
				column1 	= $_POST[input1],  

				column2		=$_POST[input2],
				column3		=$_POST[input3]";

This is a pretty common mysql insert statement...I have started working on a mssql db and get the following error.

Incorrect syntax near the keyword 'SET'.

What gives?

[YappyDog]

You are using an update format to try to do an insert. MySql may support this, MSSql apparently does not. Use the format that is listed at the top of your MySql link and you should be fine.

Insert into mytable (col1, col2, col3)
Values ('val1', 'val2', 'val3')

[Roger_Ramjet]

MS SQL definitely does not support the SET syntax for an INSERT