@Erland - my mistake. I had meant "SQL Server Management Studio presents the date in the format that is configured on the server", not SQL Server.

I believe SSMS always present...

SQL Server presents the date in the format that is configured on the server.

SQL Server does not present the date in any format at all! SQL Server is a database...

SQL Server 2008 does not have a date data type -- it has datetime & smalldatetime. What is the actual data type in SQL Server?

SQL 2008 does indeed have the...

I fired up SSMS17, and it seems that Ctrl+9 was bound to Edit.GotoBrace, which has a different default key binding in SSMS18.  I'm not fully certain that this is the...

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://www.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...