Custom Delimiter in SQL Server Management Studio does not work-CodePudding

I'm trying to change my delimiter to a pipe:

I have restarted SQL Server Management Studio. However, I keep having the csv file with the previous delimiter.

Is it necessary to do something else?

CodePudding user response：

You are setting custom delimiter for Results to Text option. But, you are trying to save results in the Results to Grid option.

If you are having Results to Text option (Shortcut Ctrl T), you will get the result properly. You can copy and save the result accordingly.

enter image description here

update:

SET NOROWCOUNT ON -- Add this setting before SELECT query
SELECT ...

Or in the

Tools > Options > Query Execution > SQL Server > Advanced > check SET NOROWCOUNT

Tools > Options > Query Execution > SQL Server > Advanced. Uncheck the Show Completion Time checkbox