Use a higher n number to create more segments if you still run out of memory when you try to copy and paste the first segment. Running the code should produce the same number of returned result sets as the n value you provided. Once the data is written to the table #QueryResult run the code below in the same SSMS window the temp table was created in. Start by leaving n set to the default of 2. Then all you need to do is determine how many segments you need. NTILE(n) is a function that allocates your output into n segments, each of the same size (give or take rounding when the number of rows isn’t divisible by n). Start by writing your query results into a temporary tablet called #QueryResult, for example SELECT * INTO #QueryResult FROM TableName. Not that big a deal right? I’ve even provided some code below that will really move things along. I’d wager you probably only need the result set split into two, so you’ve to copy and paste twice rather than once. The following table shows the SQL comment indicators that you can enter in your code. Sure it’s kinda manual but trust me it’ll take less time than the options above. The code examples in this document sometimes include comments that clarify the role of an SQL statement within the code, but your own SQL programs will be easier to read and to maintain if you document them with frequent comments. You can then copy and paste the chunks into the excel file without running out of memory. I’d suggest splitting the result set into chunks. yeah that’s an efficient and effective option when you just want the damn results of an ad hoc query!!! You could use the bcp Utility but you’ve probably read leaving this option turned on represents a security risk. You could use the Management Studio export function, but this is intended for physical tables not results sets and you might not have the permissions to create tables in the environment. You’ve tried the save as option but the csv and text files have jumbled up content. There are multiple options to achieve copying data from SQL Server Management Studio to excel however most of them are a pain. So you’ve tried copying and pasting the results of a query into an excel file only to get the out of memory exception.

Sql how to comment out