Points of My Scenario:
I am studying T-SQL as a newbie/novice.
I have successfully created three tables as per commands in attached SQL script, CREATE-Tables.txt
I attempt to perform a data insert into the Sales table with the following SQL statement: " INSERT Sales SELECT NEWID(),1, 1, 4, '02/01/2012'
" - without the quotes (" "), of course! :-)
I receive the following error: "Msg 213, Level 16, State 1, Line 1. Column name or number of supplied values does not match table definition
Please correct the syntax in my T-SQL statement or advise me what I am doing wrongly. Remember that I am a newbie! :-)