WHEN @searchField = 'REF' THEN OrderReferenceNumber = @searchTerm
WHEN @searchField = 'NAM' THEN OriginalCompanyName = @searchTerm
WHEN @searchField = 'DAT' THEN CompanyFilingDate = @searchTerm
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.