<div>
# is not a proper character, sql server recognises only single quote for enclosing values.
</div>


# is not a proper character, sql server recognises only single quote for enclosing values.

<div>
Interesting...I always thought it was #.<br />
Thanx for the confirmation.
</div>


Interesting...I always thought it was #.
Thanx for the confirmation.

<div>
<div class="content wysiwyg-content">
I'm inserting data into a SQL server.<br />
Whenever I enclose my date fields in #, I get the above error.<br />
The query seems to work if I enclose them in apostrophes (')<br />
<br />
What could the problem be? &nbsp;The fields in sql are smalldatetime, and the values I'm inputting are:<br />
#12/06/2007#,#12/06/2007 11:00:00 AM#,#12/06/2007 11:30:00 AM#<br />
<br />

</div>
</div>


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#



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

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.