Re: INSERT into SQL 2000

I don't know if SQL Server is any different, but I'm not aware that there is any 'SET' keyword in an INSERT statement. The usual syntax is:

insert into table_name (column_name1, column_name2)
values (value1, value2)
[download]

I almost didn't even bother reading your post. Was it really necessary to post over 300 lines of code to demonstrate an insert statement that doesn't work?

Comment on Re: INSERT into SQL 2000 Download Code

Replies are listed 'Best First'.
Re: Re: INSERT into SQL 2000 by Anonymous Monk on Jul 14, 2003 at 22:01 UTC
I think you're correct about INSERT. Usually the SET keyword is used with an UPDATE statement, IIRC. The inquiring monk did say that it worked from a command line, though.	[reply]