Viewing 15 posts - 1,336 through 1,350 (of 2,917 total)
I think it is one of those "it depends" questions. Is it going to be used ONLY for development purposes only (ie no production data, no UAT, etc)? Then there...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 11, 2021 at 4:45 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 11, 2021 at 3:09 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 11, 2021 at 3:01 pm
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. ...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 11, 2021 at 2:46 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 10, 2021 at 9:56 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 10, 2021 at 9:54 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 10, 2021 at 8:42 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 10, 2021 at 8:38 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 10, 2021 at 8:25 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 10, 2021 at 8:16 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 10, 2021 at 6:04 pm
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 above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 10, 2021 at 4:34 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 9, 2021 at 2:32 pm
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 above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 8, 2021 at 9:21 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 5, 2021 at 2:05 pm
Viewing 15 posts - 1,336 through 1,350 (of 2,917 total)