Char(9)在SQL Server 2005中不打印选项卡 [英] Char(9) doesn't print tab in Sql server 2005

问题描述

我正在尝试使用以下命令在sql server中打印标签:

I am trying to print a tab in sql server using:

select 'tab-->' + char(9) + '<--tab'

但是它似乎不起作用并且总是打印

But it doesn't seem to work and always prints

tab--> <--tab

我有什么想念的吗?

推荐答案

如果要在Management Studio中进行测试，则 Results to Grid ( Ctrl + D )设置会将您的标签页更改为空格...尝试切换到结果转换为文本( Ctrl + T )，您将看到标签.

If you're testing this inside of Management Studio, the Results to Grid (Ctrl + D) setting will change your tab to a space... try switching to Results to Text (Ctrl + T) instead, and you will see the tab.

或者，您可以将 select 更改为 print :

Alternately, you can change your select to a print:

print 'tab-->' + char(9) + '<--tab'

输出...

tab-->  <--tab

这篇关于Char(9)在SQL Server 2005中不打印选项卡的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！