Viewing 15 posts - 1 through 15 (of 50 total)
It would be nice if they increased the DB limit in SQL Server express from 10 GB to 20 GB!
January 31, 2022 at 2:47 pm
Create function [dbo].[Translate]( @inputString varchar(max), @characters varchar(1000), @translations varchar(1000)) returns varchar(max)/*Equivalent to SQL Server Translate() function which is in SQL Server 2017 and later.*/as...
November 11, 2021 at 11:20 am
This can be done easily using the Translate() function:
If Object_id('tempdb..#IntChange') is not null Drop table #IntChange;CREATE TABLE #IntChange (NumericValue INT);INSERT INTO #IntChangeVALUES (15697) --74285 ...
November 11, 2021 at 11:19 am
I thought SQL Server Full Text Search already included filters to handle PDF and office formats 'out of the box'. But I may be completely missing the point in which...
September 20, 2021 at 11:46 am
Strange though it seems, there is a reason. You're multiplying two numbers where precision = 38 and scale = 10. The product requires precision = 77 (38 + 38 +...
July 28, 2021 at 11:15 am
I am not an internals expert, but I believe that if a table has any nullable columns it always stores a 'null bitmap' for each row to indicate the null...
July 19, 2021 at 9:21 am
You could do this with a trigger - the trigger gets the inserted XML, extracts the elements you want and checks they exist in the primary key table. If the...
July 5, 2021 at 11:09 am
This was removed by the editor as SPAM
June 28, 2021 at 11:40 am
Happy with SSMS - I've grown used to it over the years and know how to find the things I need. The only thing I miss is the TSQL debugger...
December 4, 2020 at 9:18 am
Do your applications have to change their connection strings to connect to the new 2019 instance?
November 12, 2020 at 10:25 am
There used to be a real annual Turing Test called the Loebner Prize (see https://en.wikipedia.org/wiki/Loebner_Prize or https://www.chatbots.org/awards/loebner_prize/loebner_prize/ ). This had 4 judges, 4 AI's and 4 "real people"....
October 15, 2020 at 8:43 am
I have been migrating TSQL code from SQL 2008 to later versions. The code consists of complex SPs that call more SPs that call functions, and my tests were based...
July 21, 2020 at 11:09 am
You could try importing it as a blob (use OPENROWSET with SINGLE_BLOB), this should always succeed. But you would then need to parse the string before putting it into your...
May 21, 2020 at 11:35 am
I have used TSQL and SSIS and my thoughts are:
October 31, 2019 at 11:02 am
It can be difficult to link Excel and SQL Server and many different obscure errors are possible. The issue here is likely because you are running multiple imports at the...
October 28, 2019 at 11:28 am