Insert into is valid in sql server:
USE AdventureWorks2008R2;
GO
INSERT INTO Production.UnitMeasure
VALUES (N'FT', N'Feet', '20080414');
GO

myallsql_01, cab you post error message here? You didn't specify data type for column when create table?