Page breaks

[gjsaturday]

With sql plus, I can use the command BREAK ON DEPTNO SKIP PAGE to give me a page break on each change in deptno. Is there something similar in sql server? Sorry if this is basic stuff, I'm still learning.

Thanks in advance.

 

[Catadmin]

Are you talking memory Pages or piece of paper pages with that command?

If you're talking piece of paper pages as in printing, you'll have to look up the help files in whatever reporting tool you're using.

If you're talking Memory Pages, look up Pages in Books Online. There are a lot of topics there. I think there's a way you can save certain parts of tables on different file groups (also found in BOL), but I don't know about being able to specify it across memory pages. SQL Server memory pages are only 8KB in size and even if you could break things up this way, it won't work if one of your result sets is bigger than this.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!