且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Char(9)在SQL Server 2005中不打印选项卡

更新时间:2023-02-04 07:46:25

如果要在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