Avatar of sirbounty
Flag for United States of America

asked on 

Label names must be unique within a query batch or stored procedure

I'm inserting data into a SQL server.
Whenever I enclose my date fields in #, I get the above error.
The query seems to work if I enclose them in apostrophes (')

What could the problem be?  The fields in sql are smalldatetime, and the values I'm inputting are:
#12/06/2007#,#12/06/2007 11:00:00 AM#,#12/06/2007 11:30:00 AM#

Visual Basic.NETMicrosoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon