This issue has been fixed in [SSMS 16.5 build 13.0.16000.28][1] with the addition of an option to preserve CR/LF on copy/save ([more details][2]) ([Connect bug][3]).

 1. **Tools &gt; Options**
 2. Expand **Query Results &gt; SQL Server &gt; Results to Grid**
 3. Tick **Retain CR/LF on copy or save**
 4. Restart SSMS

This will cause `CR`, `LF`, and `CRLF` to be treated as newlines when you copy a cell.


  [1]: https://msdn.microsoft.com/library/mt238290.aspx
  [2]: https://msdn.microsoft.com/library/ms190078.aspx#Anchor_0
  [3]: https://connect.microsoft.com/SQLServer/feedback/details/735714

Answering this for myself because I can never remember where this is:

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/Vb6LW.png

it is a hack, but try this:

wrap your result set in a REPLACE (.....,CHAR(13)+CHAR(10),CHAR(182)) to preserve the line breaks, you can then replace them back

    SELECT 
        REPLACE (&#39;line 1&#39; + CHAR(13) + CHAR(10)+ &#39;line 2&#39; + CHAR(13) + CHAR(10) + &#39;line 3&#39;
                ,CHAR(13)+CHAR(10),CHAR(182)
                )

OUTPUT:


    ----------------------
    line 1&#182;line 2&#182;line 3
    
    (1 row(s) affected)

replace them back in SQL:


    select replace(&#39;line 1&#182;line 2&#182;line 3&#39;,CHAR(182),CHAR(13)+CHAR(10))

output:


    -------------------
    line 1
    line 2
    line 3
    
    (1 row(s) affected)

or in a good text editor.



One thing you can do is send results to a file, then use an editor capable of watching a file for changes which has superior capabilities for understanding the output.

Suppose I know a function name, but I don&#39;t know which file it&#39;s declared in. What Eclipse keyboard shortcut can take me to the function I&#39;m looking for?


----------


What I&#39;m looking for is similar to Eclipse&#39;s: 

&lt;kbd&gt;Ctrl&lt;/kbd&gt; + &lt;kbd&gt;Shift&lt;/kbd&gt; + &lt;kbd&gt;R&lt;/kbd&gt; 

except it will search for method names instead.


----------

Sidenote
--------

With Visual Assist X, I can do this by using the &quot;Find Symbol&quot; feature, which is executed with:

&lt;kbd&gt;Shift&lt;/kbd&gt; + &lt;kbd&gt;Alt&lt;/kbd&gt; + &lt;kbd&gt;S&lt;/kbd&gt; 

Eclipse keyboard shortcut: goto function name

For instance, I am setting an interval like

    timer = setInterval(fncName, 1000);

and if i go and do

    clearInterval(timer);

it does clear the interval but is there a way to check that it cleared the interval? I&#39;ve tried getting the value of it while it has an interval and when it doesn&#39;t but they both just seem to be numbers.

Is there a way to check if a var is using setInterval()?

When I have a result set in the grid like:

    SELECT &#39;line 1
    line 2
    line 3&#39;

or

    SELECT &#39;line 1&#39; + CHAR(13) + CHAR(10) + &#39;line 2&#39; + CHAR(13) + CHAR(10) + &#39;line 3&#39;

With embedded CRLF, the display in the grid appears to replace them with spaces (I guess so that they will display all the data).

The problem is that if I am code-generating a script, I cannot simply cut and paste this.  I have to convert the code to open a cursor and print the relevant columns so that I can copy and paste them from the text results.

Is there any simpler workaround to preserve the CRLF in a copy/paste operation from the results grid?

The reason that the grid is helpful is that I am currently generating a number of scripts for the same object in different columns - a bcp out in one column, an xml format file in another, a table create script in another, etc...

SSMS Results to Grid - CRLF not preserved in copy/paste - any better techniques?

When I have a result set in the grid like:
<pre><code class="hljs language-scss">SELECT 'line 1
line 2
line 3'
</code></pre>
or
<pre><code class="hljs language-scss">SELECT 'line 1' + CHAR(13) + CHAR(10) + 'line 2' + CHAR(13) + CHAR(10) + 'line 3'
</code></pre>
With embedded CRLF, the display in the grid appears to replace them with spaces (I guess so that they will display all the data).
The problem is that if I am code-generating a script, I cannot simply cut and paste this. I have to convert the code to open a cursor and print the relevant columns so that I can copy and paste them from the text results.
Is there any simpler workaround to preserve the CRLF in a copy/paste operation from the results grid?
The reason that the grid is helpful is that I am currently generating a number of scripts for the same object in different columns - a bcp out in one column, an xml format file in another, a table create script in another, etc...

I am reading through the SQL Server 2008 bible and I am covering the views section. But the author really doesn&#39;t explain the *purpose* of views. What is a good use for views? Should I use them in my website and what are the benefits of them?

What is a good reason to use SQL views?

I am trying to create some script variables in T-SQL as follows:

        /*
        Deployment script for MesProduction_Preloaded_KLM_MesSap
        */
        
        GO
        SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
        
        SET NUMERIC_ROUNDABORT OFF;
        
        
        GO
        :setvar DatabaseName &quot;MesProduction_Preloaded_KLM_MesSap&quot;

However, when I run this, I get an error stating &#39;Incorrect syntax near &#39;:&#39;. What am I doing wrong?



SQL Server &#39;:setvar&#39; Error

&gt; table1 (id, name)     
table2 (id, name)

 Query:

    SELECT name   
    FROM table2  
    -- that are not in table1 already

How to select all records from one table that do not exist in another table?

Something like this:

    SELECT
    * 
    FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS 
    WHERE CONSTRAINT_NAME =&#39;FK_TreeNodesBinaryAssets_BinaryAssets&#39;
    and TABLE_NAME = &#39;TreeNodesBinaryAssets&#39;

but for indexes.

How do you check if a certain index exists in a table?

I have recently updated my system to record date/times as UTC as previously they were storing as local time.

I now need to convert all the local stored date/times to UTC. I was wondering if there is any built in function, similar to .NET&#39;s `ConvertTime` method?

I am trying to avoid having to write a utility app to do this for me.

Any suggestions?

SQL Server - Convert date field to UTC

I want to output an integer to a `std::stringstream` with the equivalent format of `printf`&#39;s `%02d`. Is there an easier way to achieve this than:

    std::stringstream stream;
    stream.setfill(&#39;0&#39;);
    stream.setw(2);
    stream &lt;&lt; value;

Is it possible to stream some sort of format flags to the `stringstream`, something like (pseudocode):

    stream &lt;&lt; flags(&quot;%02d&quot;) &lt;&lt; value;

Equivalent of %02d with std::stringstream?

I am trying to print an integer in [JavaScript][1] with commas as thousands separators. For example, I want to show the number 1234567 as &quot;1,234,567&quot;. How would I go about doing this? 

Here is how I am doing it:

    function numberWithCommas(x) {
        x = x.toString();
        var pattern = /(-?\d+)(\d{3})/;
        while (pattern.test(x))
            x = x.replace(pattern, &quot;$1,$2&quot;);
        return x;
    }

Is there a simpler or more elegant way to do it? It would be nice if it works with floats also, but that is not necessary. It does not need to be locale-specific to decide between periods and commas. 

  [1]: http://en.wikipedia.org/wiki/JavaScript





















                 


How to print a number with commas as thousands separators in JavaScript

Before you ignore / vote-to-close this question, I consider this a *valid* question to ask because **code clarity** is an important topic of discussion, it&#39;s essential to writing maintainable code and I would greatly appreciate answers from those who have come across this before.

I&#39;ve recently run into this problem, LINQ queries can get pretty nasty real quick because of the large amount of nesting.

Below are some examples of the differences in formatting that I&#39;ve come up with (for the same relatively non-complex query)

**No Formatting**

    var allInventory = system.InventorySources.Select(src =&gt; new { Inventory = src.Value.GetInventory(product.OriginalProductId, true), Region = src.Value.Region }).GroupBy(i =&gt; i.Region, i =&gt; i.Inventory);

**Elevated Formatting**

    var allInventory = system.InventorySources
    	.Select(src =&gt; 
    		new { 
    			Inventory = src.Value.GetInventory(product.OriginalProductId, true), 
    			Region = src.Value.Region })
    				.GroupBy(
    					i =&gt; i.Region, 
    					i =&gt; i.Inventory);
	
**Block Formatting**
				
    var allInventory = system.InventorySources
    	.Select(
    		src =&gt; new 
    		{ 
    			Inventory = src.Value.GetInventory(product.OriginalProductId, true), 
    			Region = src.Value.Region 
    		})
    		.GroupBy(
    			i =&gt; i.Region, 
    			i =&gt; i.Inventory
    		);

**List Formatting**		

    var allInventory = system.InventorySources
    	.Select(src =&gt; new { Inventory = src.Value.GetInventory(product.OriginalProductId, true), Region = src.Value.Region })
    	.GroupBy(i =&gt; i.Region, i =&gt; i.Inventory);

I want to come up with a standard for linq formatting so that it maximizes readability &amp; understanding and looks clean and professional. So far I can&#39;t decide so I turn the question to the professionals here.

Best ways to format LINQ queries

I&#39;m writing a Bash script that prints some text to the screen:

    echo &quot;Some Text&quot;

Can I format the text? I would like to make it bold.

How does one output bold text in Bash?

I have a column `DECIMAL(9,6)` i.e. it supports values like 999,123456.

But when I insert data like 123,4567 it becomes 123,456700

How to remove those zeros?

Remove trailing zeros from decimal in SQL Server

In this live SQL Server 2008 (build 10.0.1600) database, there&#39;s an `Events` table, which contains a `text` column named `Details`. (Yes, I realize this should actually be a `varchar(MAX)` column, but whoever set this database up did not do it that way.) 

This column contains very large logs of exceptions and associated JSON data that I&#39;m trying to access through SQL Server Management Studio, but whenever I copy the results from the grid to a text editor, it truncates it at 43679 characters.

I&#39;ve read on various locations on the Internet that you can set your Maximum Characters Retrieved for XML Data in `Tools &gt; Options &gt; Query Results &gt; SQL Server &gt; Results To Grid` to Unlimited, and then perform a query such as this:

    select Convert(xml, Details) from Events
    where EventID = 13920

(Note that the data is column is not XML at all. `CONVERT`ing the column to XML is merely a workaround I found from Googling that someone else has used to get around the limit SSMS has from retrieving data from a `text` or `varchar(MAX)` column.)

However, after setting the option above, running the query, and clicking on the link in the result, I still get the following error:

&gt;Unable to show XML. The following error happened:
Unexpected end of file has occurred. Line 5, position 220160.

&gt;One solution is to increase the number of characters retrieved from the server for XML data. To change this setting, on the Tools menu, click Options.

So, **any idea on how to access this data?** Would converting the column to `varchar(MAX)` fix my woes?

How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?

Using Sql Express Management Studio 2008 GUI (not with coding), how can I make a primary key auto-incremented?

Let me explain: there is a table which has a column named &quot;id&quot; and the items of this column are set to be primary keys. I want to make this column auto-incremented, but how?

Cheers

Auto-increment primary key in SQL tables

    CREATE TABLE [dbo].[user](
        	[userID] [int] IDENTITY(1,1) NOT NULL,
        	[fcode] [int] NULL,
        	[scode] [int] NULL,
        	[dcode] [int] NULL,
        	[name] [nvarchar](50) NULL,
        	[address] [nvarchar](50) NULL,
         CONSTRAINT [PK_user_1] PRIMARY KEY CLUSTERED 
        (
        	[userID] ASC
        )
        ) ON [PRIMARY]
        
        GO

How do I add a unique constraint for columns `fcode, scode, dcode` with `t-sql` and/or `management studio`? `fcode, scode, dcode` must be unique together.


Unique constraint on multiple columns

I want to restore a database from a file (Tasks → Restore → Database; after I select from device and select file) via SQL Server Management Studio. 

After that, I get this error:

&gt; The operating system returned the error &#39;5(Access is denied.)&#39; while attempting
&#39;RestoreContainer::ValidateTargetForCreation&#39; on &#39;E:\Program Files\Microsoft SQL
 Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\XXXXXX.mdf&#39;.
Msg 3156, Level 16, State 8, Server XXXX, Line 2

How do I fix this problem? Is it a security error?

mssql &#39;5 (Access is denied.)&#39; error during restoring database

Is there any way I can find in SQL Server Management Studio stored procedure by name or by part of the name? (on active database context)

Thanks for help

Content Type	Original Author	Original Content on Stackoverflow
Question	Cade Roux	View Question on Stackoverflow
Solution 1 - Sql Server	Charles Gagnon	View Answer on Stackoverflow
Solution 2 - Sql Server	Joe Shakely	View Answer on Stackoverflow
Solution 3 - Sql Server	KM.	View Answer on Stackoverflow
Solution 4 - Sql Server	adolf garlic	View Answer on Stackoverflow

SSMS Results to Grid - CRLF not preserved in copy/paste - any better techniques?

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Solution 4 - Sql Server

Is there a way to check if a var is using setInterval()?

Eclipse keyboard shortcut: goto function name

Attributions