| Author |
Topic |
|
dmilam
Posting Yak Master
185 Posts |
 Posted - 2010-05-14 : 13:19:28
|
| [code]Select P.Description, P.Code, ...from Promotion as P[/code]This description is of type nvarchar(256); the results returned are only 9 characters long, so the remaining 247 characters are apparently 'filled out' with blanks, but this makes the result pane very wide, so that I have to scroll to the right to see the rest of the results. Yes, I could put the Description at the end, but I want to see it first. Any way to have the result truncated exactly to the length of the text string returned? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-14 : 13:23:14
|
| if problem is just viewing results in SQL management studio then why not use view in grid option (Ctrl + D). why change query for that?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dmilam
Posting Yak Master
185 Posts |
Posted - 2010-05-14 : 13:27:45
|
| Thanks, Tara! I do need the result in text format, so this is very helpful. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-14 : 13:31:23
|
| but cant you do this copy paste also from grid format?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-05-14 : 18:23:19
|
| Tara - are you aware that you can now setup the grid options to include column headers? Personally, I do a cut/paste from the grid with this option turned on into an Excel spreadsheet. Users like this a lot better because then they don't have to import it themselves.But, I agree - for quick and easy results to an email the text view works quite well.I have used all of the above. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-15 : 02:57:48
|
quote:
Originally posted by jeffw8713
Tara - are you aware that you can now setup the grid options to include column headers? Personally, I do a cut/paste from the grid with this option turned on into an Excel spreadsheet. Users like this a lot better because then they don't have to import it themselves.But, I agree - for quick and easy results to an email the text view works quite well.I have used all of the above.
I mostly use the grid format and i'm more comfortable with it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-05-17 : 05:23:27
|
quote:
Originally posted by visakh16
quote:
Originally posted by jeffw8713
Tara - are you aware that you can now setup the grid options to include column headers? Personally, I do a cut/paste from the grid with this option turned on into an Excel spreadsheet. Users like this a lot better because then they don't have to import it themselves.But, I agree - for quick and easy results to an email the text view works quite well.I have used all of the above.
I mostly use the grid format and i'm more comfortable with it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
I too. But when it comes to perfect formation, text mode works goodIn my blogpost, If I need to show the output, I use text mode to get it so that it has a good formationMadhivananFailing to plan is Planning to fail |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
How to truncate row result?