The problem is your setting on SSMS, not that the data doesn’t have a line break. Go to: Tools -> Options -> Query Results -> SQL Server -> Results to Grid -> Retain CR/LF on copy or Save and make sure the option is ticked.
No, SQL Server Express LocalDB doesn’t accept remote connections. The idea with shared network folder might work, but only if you are able to make sure the LocalDB instance is shutdown before you try to copy the file. Also keep in mind that only one LocalDB instance can have any given database file open at … Read more
That is because null on either side of the addition operator will yield a result of null. You can use ISNULL(LiabilityPremium, 0) Example: ISNULL(l.LiabilityPremium,0) + ISNULL(h.LiabilityPremium,0) as LiabilityPremium or you can use COALESCE instead of ISNULL. COALESCE(l.LiabilityPremium,0) + COALESCE(h.LiabilityPremium,0) as LiabilityPremium Edit I am not sure if this is coincidence with this small data set … Read more
Although this has already been answered, I see people are repeatedly getting the same error that I did when trying to solve it. If when you run: C:\windows\system32> lodctr /r you get the error Error: Unable to rebuild performance counter setting from system backup store, error code is 2 then you instead need to run … Read more
You can use a combination of STUFF and CHARINDEX to achieve what you want: SELECT STUFF(col, CHARINDEX(‘substring’, col), LEN(‘substring’), ‘replacement’) FROM #temp CHARINDEX(‘substring’, col) will return the index of the first occurrence of ‘substring’ in the column. STUFF then replaces this occurrence with ‘replacement’.
I’m not sure there is an exact match for the format you want. But you can get close with convert() and style 106. Then, replace the spaces: SELECT replace(convert(NVARCHAR, getdate(), 106), ‘ ‘, “https://stackoverflow.com/”)
If you happen to be using Windows 8 and up, here’s how to get to it: The newer Microsoft SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program. It is not a stand-alone program as used in the previous versions of Microsoft Windows operating systems. SQL Server Configuration Manager doesn’t appear … Read more
Option A The ConnectionString property for an Excel Connection Manager is not where I go to manipulate the current file, which is contrast to an ordinary Flat File Connection Manager. Instead, put an expression on the Excel Connection Manager’s ExcelFilePath property. In theory, there should be no difference between ConnectionString and ExcelFilePath except that you … Read more
This is very similiar to: SELECT SUM(…) is non-deterministic when adding the column-values of datatype float. The problem is that with inaccurate datatype (FLOAT/REAL) the order of of arithmetic operations on floating point matters. Demo from connect: DECLARE @fl FLOAT = 100000000000000000000 DECLARE @i SMALLINT = 0 WHILE (@i < 100) BEGIN SET @fl = … Read more
Usually joins will work faster than inner queries, but in reality it will depend on the execution plan generated by SQL Server. No matter how you write your query, SQL Server will always transform it on an execution plan. If it is “smart” enough to generate the same plan from both queries, you will get … Read more