Viewing 15 posts - 1,801 through 1,815 (of 2,918 total)
Had not thought about that road. Here is what that script produced:
CAST([name] AS VARBINARY(MAX)) = 0x23006D0079007400650073007400
CAST('#mytest' AS VARBINARY(MAX)) = 0x236D7974657374
Other than the extra zeros they match.
These are not...
June 26, 2020 at 9:51 pm
Ok I am completely stumped on this one. I was trying to re-create the object using different flavors of dynamic SQL and casting and converting hoping I could trick SQL...
June 26, 2020 at 9:37 pm
To add to what Phil said, the error you got seems to indicate the problem:
Bulk load failed due to invalid column value in CSV data file Jobs.txt in row 477,...
June 26, 2020 at 8:16 pm
Oh that is a challenging one then. I was just trying to figure out how to reproduce that.
As a thought, I am wondering if there might be some character before...
June 26, 2020 at 8:09 pm
Just so I understand things right, you are asking if you can filter the rows from table A that are replicated based on specific criteria? if so, this is entirely...
June 26, 2020 at 7:46 pm
https://docs.microsoft.com/en-us/ef/core/modeling/entity-properties
Reading through that it sounds to me like EF doesn't support excluding columns when reading the database side of things BUT quick googles indicate that you can exclude a column...
June 26, 2020 at 5:07 pm
I expect that is possible, but it would be messy to do and error prone and I expect difficult to maintain.
When doing changes like this, my preference is to make...
June 26, 2020 at 4:50 pm
My guess with this is not a problem with the stored procedure naming but more with your permissions.
I just executed the following against a SQL Server 2016 instance and it...
June 26, 2020 at 4:39 pm
This is a double post. Did none of the answers in the previous thread help?
The query is identical...
Link:
https://www.sqlservercentral.com/forums/topic/need-help-with-sql-code
June 26, 2020 at 3:42 pm
I think the first step to troubleshooting this is knowing what error you get. Is it that it doesn't like your username/password or is it a TCP/IP error or a...
June 26, 2020 at 3:41 pm
I am guessing you mean a SQL Server service pack update, right?
If so, have you tried going to the folder it extracted the data to and looking for a "setup.exe"...
June 26, 2020 at 3:37 pm
A test environment is good for this and for other things too.
If you want to deploy a report for an end user to test (for example), this works great! Or...
June 25, 2020 at 9:55 pm
As to what is in the logs, that I am not sure. I don't know what specific error messages will pop up, but the log will tell you exactly what...
June 25, 2020 at 9:03 pm
Doing a quick google on error ORA-00933 - it sounds like that shouldn't be thrown with a SELECT statement. Is there more to the query that you did not include...
June 25, 2020 at 8:43 pm
If the app is changing data and is doing it in a transaction, it could be they forgot to put a COMMIT in there. Unlikely, but possible.
The other thing that...
June 25, 2020 at 8:23 pm
Viewing 15 posts - 1,801 through 1,815 (of 2,918 total)