I would use varbinary(MAX), since the encrypted data is just a bunch of bits, which makes very little sense as characters.

Duplicate thread: https://qa.sqlservercentral.com/forums/topic/insert-records-with-a-where-2

Your post is anything but clear. Bear in mind that I know nothing about your job or what a "job allocation" is.

But may this is what you want:

            
October 22, 2021 at 3:35 pm
            
#3943332

            
            
                                                
        

A new feedback site is now available: https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0

Old feedback items, including votes, have seems to have been migrated.

Edit the database file in a hex editor is certainly an option. ....but it is not for the faint of heart, but requires good knowledge of SQL Server internals. I...

Just to add what Grant says: Both Express and Developer Edition are free. Express has lesser features and a cap on the database size, but it is licensed for production...

Task scheduler it is, then. Keep in mind that Task Scheduler runs under Local System which typically does not have access to SQL Server, so you will have to arrange...

Just wondering if I'm want to be further as Data Analyst with any kind of ERP, because by then, I may not be familiar with the table's name and how...

A 900-line query? Generated from a system? I would say that more than one person on this list, would simply give up. I would certainly be inclined. ratbak and Thom...

An issue with using sqlcmd for this is it won't return a failure if the SQL fails, only if there's a major error like cannot connect to server. If you...

I take the number ten in the article to be a recommendation, not a strict limit that will give you an error when you add the 11th user.

Query notification is...

I'm not sure why Jeff keeps talking about the version of SQL Server. We are not talking about BULK INSERT here.

As I understood the original post, VSCurtis right-clicked the database...

To beat this dead horse a little more: CSV may be an industrial standarad - and I think everyone here knows that. But while the CSV format may include column...

To Repeat.... CSV files are industry standard files. There are NO default values for field size.

But in SQL Server all columns must have a size. No matter if CSV files...

Maybe it was a trick question where the expected answer was "you can't do that" or "that's a completely meaningless thing to do". Remember, the purpose of interview questions are...