By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,030 Members | 1,227 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,030 IT Pros & Developers. It's quick & easy.

equivalent of SET NEWPAGE NONE in SQL server 2005

P: 13
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 ',';
Feb 29 '08 #1
Share this Question
Share on Google+
4 Replies


ck9663
Expert 2.5K+
P: 2,878
What does it do?

-- CK
Feb 29 '08 #2

P: 13
What does it do?

-- CK
I am trying to convert Oracle script to SQL Server. I think those are the environment variables..
Mar 3 '08 #3

P: 13
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.
Apr 22 '08 #4

ck9663
Expert 2.5K+
P: 2,878
No idea yet on that one.

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

-- CK
Apr 23 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.