<div>
You do not need to escape commas.
</div>


<div>
Why dont you directly use the whole things inside a single quoted string<br />
i didn get your reason for using it in this way. <br />
'1900-01-01,0001-01-01'<br />
<br />
if im wrong, please correct me
</div>


Why dont you directly use the whole things inside a single quoted string
i didn get your reason for using it in this way.
'1900-01-01,0001-01-01'

if im wrong, please correct me

<div>
<div class="content wysiwyg-content">
In the 5th value I am entering below, I actually want to enter the comma in the middle. &nbsp;I want to enter this as the 5th value '''1900-01-01''','''0001-0<wbr />1-01'''. &nbsp;Is there some kind of escape character I can use to enter that in the manner described?<br />
<br />
insert into CMvCM2.dbo.LA_Analysis_Var<wbr />_MICLGCDt values (<br />
'score1',<br />
29,'-29',<br />
536870912,<br />
'd.MICLGCDt',<br />
'''1900-01-01''','''0001-0<wbr />1-01''',<br />
'b.MICLGDt',<br />
'''01-01-1900''')<br />

</div>
</div>


In the 5th value I am entering below, I actually want to enter the comma in the middle.  I want to enter this as the 5th value '''1900-01-01''','''0001-01-01'''.  Is there some kind of escape character I can use to enter that in the manner described?

insert into CMvCM2.dbo.LA_Analysis_Var_MICLGCDt values (
'score1',
29,'-29',
536870912,
'd.MICLGCDt',
'''1900-01-01''','''0001-01-01''',
'b.MICLGDt',
'''01-01-1900''')


SQL Script - Insert comma separated values with a comma in value

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.