|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
modifying output from osql command line
when running a query in query analyzer, you can set the query to result in
grid, which i preferably like over result in text. when running it through osql, i'm trying to find a way to do the same. anyone know how? I tried using the -u but the output doesn't change for me. any help would be greatly appreciated. thanks! FS Hello,
You cant do grid formatted output using OSQL. What you can do is write the output to a CSV file using BCP Queryout and open in excel. Thanks Hari Show quoteHide quote "FS" <F*@discussions.microsoft.com> wrote in message news:02D5BA8D-E224-4DA0-A5D7-5129C64300DB@microsoft.com... > when running a query in query analyzer, you can set the query to result in > grid, which i preferably like over result in text. when running it through > osql, i'm trying to find a way to do the same. anyone know how? I tried > using > the -u but the output doesn't change for me. any help would be greatly > appreciated. > thanks! > FS  
Other interesting topics
Changing the text of the code of multiple stored procedure
moving a database causes it to be read-only Clus. Index keys How to configure SQLExpress on a workgroup SQL Server Backup How to avoid creating duplicate indexes on the same column Can not change index INCLUDE fields order.... SA Password help DATABASE Mail Account Setup Error Conversion failed when converting datetime from character string |
|||||||||||||||||||||||
