Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    164

    Unanswered: Set results in a grid format or text format

    Hi,

    I know you can change the way the data is displayed by clicking on the results to text or results to grid button and also by using ctl+d and ctl+t.

    I was wondering if there was a way that you could set your results to grid or text using a command in your t-sql of your query.

    Thanks in advance!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    No. The way the result set is displayed is controlled by the SQL client software, but the Transact-SQL runs on the SQL Server machine. There isn't any "out of band" signal in the TDS stream that specifies how the results should be displayed so the standard Microsoft supplied SQL tools wouldn't support server specified presentation, although you could improvise one easily enough using MRS and a custom written SQL client.

    -PatP

  3. #3
    Join Date
    Jan 2004
    Posts
    164
    Thank you for the reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •