HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

how to set "result to text" with a tsql statement in sp?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
resulttsqlstatementwithtexthowset

Problem

is there any way to set "result to text" within of SP while this execute a process? a tsql stament?

Thanks.

Solution

"result to text" is for client application

e.g. in SSMS when you press CTRL+T, you tell the client application (SSMS) to show / render the results of the query in TEXT format.

Similarly, CTRL+D in SSMS will show the results of the query in GRID format.

Context

StackExchange Database Administrators Q#106481, answer score: 3

Revisions (0)

No revisions yet.