Something like this (it has more code and some additional logic with each of the SELECT's, which is out of the scope I have raised here) - first I check...

If I understand your code, if there are multiple changes I will have to dig through all of them, where I am more interested in the latest. I will try...

I have meant 200 rows of code

Column1,

Column2,

----

Column200

I appreciate SSMS will generate it for me, yet again, I was hoping to have neater solution, something like one would do in Oracle,...

Agree that will work too, yet still would not be a clean solution with over 200 rows.

IDENTITY would make it simpler indeed. But it is not. Primary Key though.

I didn't even know Azure can be used same as AWS, but you're right - the immediate move, they said, would be hosting, with later migration to Azure SQL. Yet,...

I have tried to use SSIS, but it seems the relevant packages, like ZappySys you have mentioned above, must be purchased separately.

Does SSIS have built-in HTTP POST functionality or is...

Thank you for the reply. I always set my test DB's to simple recovery mode, yet I have mistakenly thought setting Auto Shrink to true would be better option for...

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

Much appreciated, Lowell.

Thank you!

I wonder if there was any change since, please? In SQL 2016? I need to encrypt a response I receive from one of our credit company's interfaces in an XML...

Thank you. This is the one.