equivalent of SET NEWPAGE NONE in SQL server 2005

iitt2007

Are there any equivalent of following in SQL server 2005?

SET NEWPAGE NONE;
SET SPACE 0;
SET LINESIZE 181;
SET PAGESIZE 0;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET UNDERLINE OFF;
SET FLUSH OFF;
SET MARKUP HTML OFF;
COLUMN AGT_CD NOPRINT;
COLUMN PROC_DT NOPRINT;
SPOOL OFF;
SET COLSEP ',';

ck9663

What does it do?

-- CK

iitt2007

Quote:

Originally Posted by ck9663

What does it do?

-- CK

I am trying to convert Oracle script to SQL Server. I think those are the environment variables..

iitt2007

Hi CK,
Any idea? In Oracle, these were used for formatting the output (pooled to txt file).

Laternatively, I am lokking for how to format the values when dataset is pooled to a txt file.
Thanks in adavance.

ck9663

No idea yet on that one.

If you just want a text file output, you might want to consider BCP and OSQL

-- CK

equivalent of SET NEWPAGE NONE in SQL server 2005

re: equivalent of SET NEWPAGE NONE in SQL server 2005

re: equivalent of SET NEWPAGE NONE in SQL server 2005

re: equivalent of SET NEWPAGE NONE in SQL server 2005

re: equivalent of SET NEWPAGE NONE in SQL server 2005

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about