It would be nice if they increased the DB limit in SQL Server express from 10 GB to 20 GB!

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...

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 #IntChange
VALUES  (15697) --74285
  ...

• This reply was modified 3 years, 1 month ago by  William Rayer.

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...

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 +...

• This reply was modified 3 years, 4 months ago by  William Rayer.

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...

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...

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...

Do your applications have to change their connection strings to connect to the new 2019 instance?

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"....

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...

• This reply was modified 4 years, 5 months ago by  William Rayer.
• This reply was modified 4 years, 5 months ago by  William Rayer.

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...

I have used TSQL and SSIS and my thoughts are:

• There is a learning curve with SSIS and you need to use it in the appropriate situations. It's not worth...

• This reply was modified 5 years, 1 month ago by  William Rayer.
• This reply was modified 5 years, 1 month ago by  William Rayer.

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...