SQL Server only captures the data you give it.  So if you have no method of checking when data was inserted (modified date column for example), then you would need...

Glad I could help!

Adding clustered indexes is never a bad idea (you can have 1 per table), as long as your clustered index is on the correct column(s).  The ideal...

I just noticed my "UNICODE" examples got screwed up.

As for SheilaMajors's response about "LONG TEXT" and "MEMO", those are not valid SQL Server data types that I am aware of. ...

WHERE <date column> >= DATEADD(day,-7,GETDATE()) AND <date column> <= GETDATE()

Mind you, you may need to do some tweaking to those to make sure you are getting the EXACT...

You are right there The Dixie Flatline... the ROLLBACK rolls back all transactions.

Not sure why I thought it only did the most recent one.

COMMITs happen per transaction though.  So if...

Unicode is basically special characters OR non-english characters.  If it is all characters you can see on your keyboard and you have a USA keyboard layout, then you likely don't...

One way (not ideal) to do it would be to have the excel have the "corrected" data in worksheet 1.  Worksheet 2 has a connection to SQL and pulls in...

I think it really depends on the requirements, the source data, and the expected output.

What I mean is if you are asking for 1 date parameter and then it uses...

If the max length is 450 characters, VARCHAR(MAX) is going to be overkill.  Even VARCHAR(1000) would be overkill, but would give you wiggle room.  But it depends too.  If your...

What is in your SQL error log (ie not the windows error log)?

My guess (without seeing your system and seeing ONLY what you posted) is that there is some sort...

One thing to note about Paige031's comment is that if you use the + operator on a VARCHAR and an INT column and the VARCHAR cannot be converted to INT,...

The documents you linked say that it MUST be CHAR or VARCHAR or be able to be implicitly converted to those datatypes.  According to this website:

https://www.sqlshack.com/implicit-conversion-in-sql-server/

The implicit conversion for CHAR...

Basically, the IMPLICIT transaction being turned on means you are going to need 1 additional "COMMIT/ROLLBACK" in your statement.  IMPLICIT TRANSACTIONS being turned on is like putting an extra "BEGIN...

The error is coming from the Snowflake ODBC connector.  I would check that it is configured the same on the server where SQL is hosted and on your visual studio...

Like Pietlinden, I am not sure what you are trying to do, but one way you could do what you are asking would be with a cursors and a while...