Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
keithc1
Yak Posting Veteran
88 Posts |
 Posted - 2004-06-10 : 20:24:59
|
| Is there any way to code in a Stored Procedure or in T-SQL to have Results returned in text instead of actually clicking off menu and selecting it from there? Just to be clear I'd like to do this via T-SQLKeithc MCSE MCSA |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-06-10 : 20:27:53
|
| NoThe display of the results is a function of Query Analyzer and not TSQL.Why do you need to do it this way ?Damian |
 |
|
|
keithc1
Yak Posting Veteran
88 Posts |
Posted - 2004-06-10 : 20:59:23
|
| Really don't need it that way I was just am trying to do everything I can using T-SQL and some times i'll run a proc that once in grid isn't the format i wanted or vice versa then I have to click etc then re-run to get results the way I want for readability. I'd rather type it out to tell you the truth, be nice to have like a SET QA(Txt) on or something like that.Keithc MCSE MCSA |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-06-10 : 21:08:41
|
| I seeYou are out of luck there sorry.You can set the default format to text in the Options -> Results tab.Damian |
|
|
|
keithc1
Yak Posting Veteran
88 Posts |
Posted - 2004-06-10 : 22:27:17
|
| Hey Merkin thanks for the help, just became member here and hope to get some help time to time. Very new to sql, I have couple home systems setup with SQL and am working torwards Cert hoping to get an edge (MCSE doesn't quite get you a job anymore) but maybe MCSE and MCDBA gets me a better chance. Just working way through couple books right now.Guru's Guide to SQL SERVER Stored procedures and XML by HendersonandSql Programming book By Veraany other good ones or advice be great thanksKeithc MCSE MCSA |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-10 : 23:31:16
|
| The Guru's Guide is a good start. :) Also look at his internals book. You should also look at anything published by Kalen Delaney (Inside SQL Server 2000) and The Performance Tuning Technical Reference by Microsoft Press.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-06-11 : 13:43:18
|
| I just bought "Microsoft SQL Server 200 Performance Optimization and Tuning Handbook" by Ken England and it's quite good... |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-11 : 14:23:06
|
| btw you're looking for bcp with a format file..do you have sql server books online?orBOLBrett8-) |
|
|
|
|
|
|
Results In Text