Ok.  Great.  Thank you.

"A person would do an explicit conversion because they are just plain lazy or really do not understand how these things work."

Did you mean to say implicit conversion?  I would...

Yeah I went through this with SSIS/SSDT. That error refers to the "Microsoft Access Database Engine 2010 Redistributable" I think. You can download that from here: https://www.microsoft.com/en-in/download/details.aspx?id=13255 There...

Ok.  If I use the CASE statement, could I still use that in my code above?  Where would it go?  Would it actually go in the SELECT statement?  It would...

Thank you for the link, but I have Windows 10 and that is not listed in the compatible operating systems.  Any ideas?

Here is what I tried:

use master;

go

ALTER AUTHORIZATION ON DATABASE::AdventureWorksDW2016CTP3 TO [DESKTOP-8J18OSS\SQLEXPRESS2017];

In the Object Explorer at the very top level it says DESKTOP-8J18OSS\SQLEXPRESS2017 which is where I got...

TRIM can remove characters other than spaces, LTRIM and RTRIM an only remove spaces

So if I wanted to remove specific characters from the left or right, how could I do...

Sue with the following code

SELECT LEN(LTRIM('.' FROM '.....SSMS.....'))

I was attempting to TRIM/remove all the  '.'  to the left of the letters SSMS, which would return:  SSMS.....

The TRIM...

Ok.  I didn't know that.  Good to know.  Thank you.

Joe,

Suppose that on SQL server we have 5 databases.

When a schema groups database objects, do all those objects have to be within the same database?

Or can a schema include some...

I understand Update will be in effect until it is revoked. What I am wondering is how is it possible for the user to do a write operation on...

This really helps to clear things up. Thank you.

For server roles, the user only has 'public.' For database roles the user has db_backupoperator and db_datareader.