Tag Info

New answers tagged


The difference is not hidden - simply your examples don't illustrate it :-) Using INSERT TableName (Column1, Column2) VALUES ... syntax limits your options to values lists (as in your examples; note that the value list should be enclosed in parentheses.) or return value of stored procedure e.g. INSERT INTO Cities (Location) VALUES ( dbo.CreateNewPoint(x, ...

Top 50 recent answers are included