blocks|key|1100145|text|我不认为有任何选择可以实现这一点-我担心你将不得不接受这些头文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1100146|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I don't think there's any option available to achieve this - you'll have to live with those headers, I'm afraid.

blocks|key|1100529|text|我没有在一个地方看到所有这些信息，我想下一个寻找它的人可能会喜欢它……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1100530|使用-h+-1选项从输出中删除短划线(-)，使用SET+NOCOUNT+ON删除“受影响的行”。如果您要为另一个系统创建报告或CSV文件以进行处理，则此功能非常有用。|offset|length|style|CODE|1100531|示例：|1100532|SQLCMD+-S+127.0.0.1\SQL_SERVER_Instance+-d+db_name+-U+db_login+-P+password+-i+your_script.sql+-o+your_output.csv+-h+-1|code-block|syntax|javascript|1100533|在您的SQL脚本中：|1100534|SET+NOCOUNT+ON+--+removes+(rows+affected+from+the+output)
select+'your_column_1,+your_column_2'
select+*+from+your_table|1100535|为此，您不需要在select语句之间使用union。|1100536|entityMap^0|0|2|5|O|E|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]|$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|13|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|15|8|@]|9|@]|A|$M|N]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|V|$]]

I didn't see all this info in once place and thought the next person looking for it might appreciate it... 

use the <code>-h -1</code> option to remove the dashes (--------) from the output and <code>SET NOCOUNT ON</code> to remove the "rows affected". This is great if you're creating a report or CSV file for another system to process.

Example:

<pre><code>SQLCMD -S 127.0.0.1\SQL_SERVER_Instance -d db_name -U db_login -P password -i your_script.sql -o your_output.csv -h -1
</code></pre>

In your SQL script:

<pre><code>SET NOCOUNT ON -- removes (rows affected from the output)
select 'your_column_1, your_column_2'
select * from your_table
</code></pre>

You don't need to use a union between your select statements for this.

blocks|key|1315151|text|我唯一能想到的就是使用-h+-1开关删除标题，并将列名作为第一行添加到SQL查询中：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1315152|SELECT+'FirstName'+as+FirstName,+'LastName'+as+LastName
UNION
SELECT+top+5+FirstName,+LastName+FROM+Person.Contact|code-block|syntax|javascript|1315153|请注意，如果存在(var)char以外的其他数据类型，则需要使用：CAST(MyColumnName+AS+varchar(32))+as+MyColumnName转换该字段|1315154|entityMap^0|B|5|0|0|8|9|X|1D|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

The only thing I can think of is removing the header using the <code>-h -1</code> switch and adding the column names as the first row to the SQL Query:

<pre><code>SELECT 'FirstName' as FirstName, 'LastName' as LastName
UNION
SELECT top 5 FirstName, LastName FROM Person.Contact
</code></pre>

Note that if there are other data types then <code>(var)char</code>, you need to convert the field using : <code>CAST(MyColumnName AS varchar(32)) as MyColumnName</code>

blocks|key|1315287|text|只使用sqlcmd和Windows命令行，不使用存储过程：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1315288|REM+Get+the+column+headers+("set+nocount+on"+is+necessary+to+suppress+the+rows+affected+message)
sqlcmd+-S+MyServer+-Q+"set+nocount+on;select+top+0+*+from+MyDatabase.MySchema.MyTable"+-o+"MyTableColumns.csv"+-s+","+-W

REM+Remove+hyphen+line
findstr+/R+/C:"%5E[%5E-]*$"+MyTableColumns.csv+>+MyTableHeader.csv

REM+Get+data+without+headers
sqlcmd+-S+MyServer+-Q+"set+nocount+on;select+*+from+MyDatabase.MySchema.MyTable"+-o+"MyTableData.csv"+-h+-1+-s+","+-W
REM+You+can+also+use+bcp+for+this+step
REM+bcp+"select+*+from+MyDatabase.MySchema.MyTable"+queryout++"MyTableData.csv"++-c+-t","+-r"\n"+-S+MyServer+-T

REM+Append+header+and+data
type+MyTableHeader.csv+MyTableData.csv+>+MyTableDataWithHeader.csv|code-block|syntax|javascript|1315289|要处理内部带有分隔符的数据(例如"Atlanta，GA")，您需要单独指定字段(而不是使用"select+*")，并使用SQL+Server中的QUOTENAME函数。|1315290|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Using only sqlcmd and the Windows command line, with no stored procedures:

<pre><code>REM Get the column headers ("set nocount on" is necessary to suppress the rows affected message)
sqlcmd -S MyServer -Q "set nocount on;select top 0 * from MyDatabase.MySchema.MyTable" -o "MyTableColumns.csv" -s "," -W

REM Remove hyphen line
findstr /R /C:"^[^-]*$" MyTableColumns.csv &gt; MyTableHeader.csv

REM Get data without headers
sqlcmd -S MyServer -Q "set nocount on;select * from MyDatabase.MySchema.MyTable" -o "MyTableData.csv" -h -1 -s "," -W
REM You can also use bcp for this step
REM bcp "select * from MyDatabase.MySchema.MyTable" queryout "MyTableData.csv" -c -t"," -r"\n" -S MyServer -T

REM Append header and data
type MyTableHeader.csv MyTableData.csv &gt; MyTableDataWithHeader.csv
</code></pre>

To handle data with delimiters inside (for example "Atlanta, GA") you'll need to specify the fields separately (rather than use "select *") and use the QUOTENAME function in SQL Server.

blocks|key|1100232|text|或者可以通过sed对输出进行后处理：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1100233|sqlcmd+...+%7C+sed+-e+'2d'|code-block|syntax|javascript|1100234|删除第二行？|1100235|您可以从http://gnuwin32.sourceforge.net/packages/sed.htm获取Win32+sed|offset|length|1100236|entityMap|0|LINK|mutability|MUTABLE|url|http://gnuwin32.sourceforge.net/packages/sed.htm^0|0|0|0|4|1C|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

Or maybe post-process the output through sed as:

<pre><code>sqlcmd ... | sed -e '2d'
</code></pre>

to delete the second line?

You can get a Win32 sed from <a href="http://gnuwin32.sourceforge.net/packages/sed.htm" rel="noreferrer">http://gnuwin32.sourceforge.net/packages/sed.htm</a>

blocks|key|1315630|text|您可以执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1315631|exec+'sqlcmd+-S+YourServer+-E+-Q+"set+nocount+on;+select+*+from+YourTable"+-s+","+-W+%7C+findstr+/R+/C:"%5E[%5E-]*$"+>+yourfile.csv'|code-block|syntax|javascript|1315632|这将一举创建一个带有标题的csv文件，不带破折号，并修剪好空白区域。基于MichaelM上面的回答。|1315633|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can do the following:

<pre><code>exec 'sqlcmd -S YourServer -E -Q "set nocount on; select * from YourTable" -s "," -W | findstr /R /C:"^[^-]*$" &gt; yourfile.csv'
</code></pre>

This will create a csv file with the headers, without the dashes, and trimmed white space, in one fell swoop. Based on MichaelM's answer above.

blocks|key|1100620|text|我不得不做大量的研究，因为这里没有一个答案完全符合我的要求。因此，我将总结一下，希望它能帮助其他人。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1100621|对我来说，最简单的方法是使用sed。虽然这里已经建议这样做，但同时运行sqlcmd和sed的语法不正确。如果您使用的是Windows，就像我一样，请访问http://gnuwin32.sourceforge.net/packages/sed.htm下载sed|offset|length|style|CODE|1100622|我的最后一个命令类似于：|1100623|SQLCMD+-m+1+-S+"userpc\SQLEXPRESS"+-E+-i+"C:\someDirectory\sqlfile.sql"+-W+-s+","+-o+"C:\someDirectory\output.csv"+&&+sed+-i+2d+"C:\someDirectory\output.csv"|code-block|syntax|javascript|1100624|哪里|1100625|--m+1消除了“已更改的数据库上下文...”线路|1100626|-&&如果第一个命令运行成功，则运行第二个命令|1100627|-sed+-i+2d删除包含连字符的第二行，并将sed的输出覆盖到原始输出|1100628|请注意，sed输出文件名必须与sqlcmd的输出匹配，否则sqlcmd的输出将不会被正确覆盖。上面回答的sed语句中的2d周围不应该有引号，并且出现在它们的文档中，否则会出现错误。|1100629|希望这能有所帮助！|1100630|entityMap|0|LINK|mutability|MUTABLE|url|http://gnuwin32.sourceforge.net/packages/sed.htm^0|0|E|3|24|1C|0|0|0|0|0|1|4|0|1|2|0|1|9|0|4|3|F|6|T|6|1G|3|1N|2|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@$D|1A|E|1B|F|G]]|9|@$D|1C|E|1D|1|1E]]|A|$]]|$1|H|3|I|5|6|7|1F|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1G|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1I|8|@$D|1J|E|1K|F|G]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1L|8|@$D|1M|E|1N|F|G]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1O|8|@$D|1P|E|1Q|F|G]]|9|@]|A|$]]|$1|W|3|X|5|6|7|1R|8|@$D|1S|E|1T|F|G]|$D|1U|E|1V|F|G]|$D|1W|E|1X|F|G]|$D|1Y|E|1Z|F|G]|$D|20|E|21|F|G]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|22|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|23|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]]]

I had to do a ton of research because none of the answers here exactly fit what I was looking for. So I am going to sum in hopes that it will help others.

For me, the easiest way was to use <code>sed</code>. While this was already suggested here, there was incorrect syntax to run sqlcmd and sed concurrently. If you're using Windows, as was the case for me, head to <a href="http://gnuwin32.sourceforge.net/packages/sed.htm" rel="nofollow noreferrer">http://gnuwin32.sourceforge.net/packages/sed.htm</a> to download sed

My final command looked something like:

<pre><code>SQLCMD -m 1 -S "userpc\SQLEXPRESS" -E -i "C:\someDirectory\sqlfile.sql" -W -s "," -o "C:\someDirectory\output.csv" &amp;&amp; sed -i 2d "C:\someDirectory\output.csv"
</code></pre>

<h2>Where</h2>

-<code>-m 1</code> eliminates the "Changed database context to..." line 
-<code>&amp;&amp;</code> runs the second command if the first command runs successfully 
-<code>sed -i 2d</code> deletes the second line containing the hyphens and overwrites the output of sed to the original output

Be aware that the <code>sed</code> output file name and the output from <code>sqlcmd</code> must match otherwise the output from <code>sqlcmd</code> will not be correctly overwritten. There should not be quotes around <code>2d</code> in the <code>sed</code> statement as answered above and is present in their documentation or you will get an error.

Hope this helps!

blocks|key|1315343|text|Public+Sub+HyphenDelete(strFilename1+As+String,+Hyphens+As+Integer)


Const+FOR_READING+=+1
Const+FOR_WRITING+=+2

strFileName+=+strFilename1

strCheckForString+=+Left("-------",+Hyphens)
Set+objFS+=+CreateObject("Scripting.FileSystemObject")
Set+objTS+=+objFS.OpenTextFile(strFileName,+FOR_READING)
strContents+=+objTS.ReadAll
objTS.Close

arrLines+=+Split(strContents,+vbNewLine)
Set+objTS+=+objFS.OpenTextFile(strFileName,+FOR_WRITING)

For+Each+strLine+In+arrLines
+++If+Not+(Left(UCase(LTrim(strLine)),+Len(strCheckForString))+=+strCheckForString)+Then
++++++objTS.WriteLine+strLine
+++End+If
Next

End+Sub|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1315344|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Public Sub HyphenDelete(strFilename1 As String, Hyphens As Integer)


Const FOR_READING = 1
Const FOR_WRITING = 2

strFileName = strFilename1

strCheckForString = Left("-------", Hyphens)
Set objFS = CreateObject("Scripting.FileSystemObject")
Set objTS = objFS.OpenTextFile(strFileName, FOR_READING)
strContents = objTS.ReadAll
objTS.Close

arrLines = Split(strContents, vbNewLine)
Set objTS = objFS.OpenTextFile(strFileName, FOR_WRITING)

For Each strLine In arrLines
 If Not (Left(UCase(LTrim(strLine)), Len(strCheckForString)) = strCheckForString) Then
 objTS.WriteLine strLine
 End If
Next

End Sub
</code></pre>

blocks|key|1315437|text|如果输出到文件，请在成功执行后尝试以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1315438|++++findstr+/v+/c:"---"+sqloutput.dat+>+finaloutput.dat|code-block|syntax|javascript|1315439|我使用“-”，因为我所有的列都超过3个字符，并且我的数据中从来没有这个字符串，但您也可以使用"-;-“来进一步降低风险，或者使用基于数据的任何分隔符来代替";”。|1315440|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If outputting to a file try the following upon successful execution:

<pre><code> findstr /v /c:"---" sqloutput.dat &gt; finaloutput.dat
</code></pre>

I use "---" as all my columns are over 3 characters and I never have that string in my data but you could also use "-;-" to reduce the risk further or any delimiter based on your data in place of the ";".

blocks|key|1100665|text|从结果中删除破折号：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1100666|EXEC+msdb.dbo.sp_send_dbmail
@profile_name+=+'testMail',
@recipients+=+'krishan@gmail.com',
@query+=+'++
SET+NOCOUNT+ON
SELECT+W.*+FROM+(
(SELECT+CAST("id"+AS+VARCHAR(5)+)+as+id+,+CAST("name"+AS+VARCHAR(50)+)as+name+)+
UNION+ALL+

SELECT+CAST(+id+AS+VARCHAR(5)+)+AS+id,+CAST+(name+AS+VARCHAR(50)+)+AS+name+from+mydb.dbo.bank
+)W
'+,
@subject+=+'Test+email',
@attach_query_result_as_file+=+1,
@query_attachment_filename='filename.xls',
@query_result_separator='+++',+++
@query_result_header+=+0

++++-----remember+@query..separator+should+be--Tab+space----|code-block|syntax|javascript|1100667|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

remove dashes from results:

<pre><code>EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'testMail',
@recipients = 'krishan@gmail.com',
@query = ' 
SET NOCOUNT ON
SELECT W.* FROM (
(SELECT CAST("id" AS VARCHAR(5) ) as id , CAST("name" AS VARCHAR(50) )as name ) 
UNION ALL 

SELECT CAST( id AS VARCHAR(5) ) AS id, CAST (name AS VARCHAR(50) ) AS name from mydb.dbo.bank
 )W
' ,
@subject = 'Test email',
@attach_query_result_as_file = 1,
@query_attachment_filename='filename.xls',
@query_result_separator=' ', 
@query_result_header = 0

 -----remember @query..separator should be--Tab space----
</code></pre>

blocks|key|1100751|text|这就是我最终得到的结果，对我来说效果很好：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1100752|sqlcmd+-S+12.34.56.789+-i+"C:\Qry.sql"+-s","+-W+-w1000+%7C+findstr+/V+/R+/C:"%5E[-,]*$"+>+Reprt.csv|code-block|syntax|javascript|1100753|我相信在这一点上，findstr和regex是所有需要解释的：|1100754|findstr+/V+/R+/C:"%5E[-,]*$"|1100755|正则表达式声明“在开始的%5E，有一个或或，[-,]任意次数的*，直到您到达行$的末尾。|offset|length|style|CODE|1100756|/V的意思是，显示任何不匹配的内容。|1100757|它后面的>将显示重定向到一个文件。|1100758|我还在我的SQL文件中添加了以下内容：|1100759|SET+NOCOUNT+ON;|1100760|entityMap^0|0|0|0|0|C|1|K|4|T|1|11|1|0|0|2|0|4|1|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@$M|15|N|16|O|P]|$M|17|N|18|O|P]|$M|19|N|1A|O|P]|$M|1B|N|1C|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1D|8|@$M|1E|N|1F|O|P]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1G|8|@$M|1H|N|1I|O|P]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1J|8|@]|9|@]|A|$]]|$1|W|3|X|5|D|7|1K|8|@]|9|@]|A|$E|F]]|$1|Y|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]]|Z|$]]

This is what I ended up with and works well for me:

<pre><code>sqlcmd -S 12.34.56.789 -i "C:\Qry.sql" -s"," -W -w1000 | findstr /V /R /C:"^[-,]*$" &gt; Reprt.csv
</code></pre>

I believe at this point, the findstr &amp; regex are all that needs to be explained:

<pre><code>findstr /V /R /C:"^[-,]*$"
</code></pre>

The regex states "At the beginning <code>^</code>, has either - or , <code>[-,]</code> any number of times <code>*</code>, until you reach the end of the line <code>$</code>.

<code>/V</code> means, show me anything that doesn't match.

The <code>&gt;</code> following it redirects the display to a file.

I did also add this to my SQL file:

<pre><code>SET NOCOUNT ON;
</code></pre>

blocks|key|1315322|text|下面这行代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1315323|findstr+/R+/C:"%5E[%5E-]*$"+MyTableColumns.csv+>+MyTableHeader.csv|code-block|syntax|javascript|1315324|是非常危险的，因为它删除了所有包含"-“的行。你最好看看findstr+/？并使用类似如下的内容：|1315325|findstr+/B+/V+/C:"-----"+MyTableColumns.csv+>+MyTableHeader.csv|1315326|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The following line:

<pre><code>findstr /R /C:"^[^-]*$" MyTableColumns.csv &gt; MyTableHeader.csv
</code></pre>

is very dangerous as it removes all lines containing a "-".
You better have a look at findstr /? and use something like:

<pre><code>findstr /B /V /C:"-----" MyTableColumns.csv &gt; MyTableHeader.csv
</code></pre>

blocks|key|1100561|text|如果您想假脱机数据，那么您可以设置以下开关：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1100562|设置下划线关闭；|1100563|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

if you want to spool the data out then you can set the following switch: 

SET UNDERLINE OFF;

How can I suppress hyphens (------------) from the results set of this <code>sqlcmd</code> command:

<pre><code>C:\temp&gt;sqlcmd -d AdventureWorks -s ";" 
 -Q "SET NOCOUNT ON SELECT top 5 FirstName, LastName FROM Person.Contact;"
FirstName ;LastName
--------------------------------------------------;----------------------------
Gustavo ;Achong
Catherine ;Abel
Kim ;Abercrombie
Humberto ;Acevedo
Pilar ;Ackerman

C:\temp&gt;
</code></pre>

How to suppress hyphens in SQLCMD

SQL Server

数据库

Windows

如何从此sqlcmd命令的结果集中取消连字符(-)：C:\temp>sqlcmd -d AdventureWorks -s ";"  -Q "SET NOCOUNT ON SELECT top 5 FirstName, LastName FROM Person.Contact;"FirstName                                         ;LastName-

问如何在SQLCMD中抑制连字符
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQLCMD中抑制连字符EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQLCMD中抑制连字符
EN