Viewing 15 posts - 2,626 through 2,640 (of 59,067 total)
OK, I will try to make this clear. The dates in my tables have timestamps including milliseconds which makes it almost impossible that one date in Table A would...
October 4, 2022 at 3:26 pm
like [ \t] is used for spaces and tabs, is there anything for finding carriage return in TSQL
ex
where Result =
'Uwon'
For T-SQL, Yes... search for CHAR(10) for the newline character...
October 4, 2022 at 3:12 pm
Amazing. I wonder if this is a "feature gone awry".
The biggest difference in the execution plans is that the one with the comments contains "ContainsInterleavedExecutionCandidates = True" and the on...
October 3, 2022 at 10:03 pm
I'm still interested in the question the Kaj asked above. Basically, what do you want to do if the there's a tie of dates at one end or the other...
October 3, 2022 at 9:25 pm
This was called a singleton SELECT in Standard SQL and it loaded one row into local storage. Microsoft generalized it.
You need to be a bit specific about what you're...
October 3, 2022 at 3:28 pm
Hello Zeff Afternoon,
BWAAA-HAAA-HAAA!!! Four letters in my name and you won't even take the time to get that right. 🙁 Sorry... moving on.
October 2, 2022 at 8:23 pm
I bought a Corsair mechanical keyboard for the same reasons. Never again. The keyboard is fine, the software is nigh unusable. This is not hyperbole. It is, hands down,...
October 2, 2022 at 8:21 pm
Actually, SELECT INTO is very explicitly documented and incredibly useful (especially for building Temp Tables without having to use CREATE TABLE). See the following link...
https://learn.microsoft.com/en-us/sql/t-sql/queries/select-into-clause-transact-sql
To quote from the FROM...
October 2, 2022 at 8:08 pm
It would be nice if the example data script actually worked. 😉 Here are the results then I try to load the data for the Customer_Orders.
Msg 2627,...
October 1, 2022 at 10:27 pm
Could you give me advice on where I should learn SQL and Python to become high-skill engineer?
Most tutorials and courses seem here to focus on the querying part of...
October 1, 2022 at 10:07 pm
Hello,
Before migrating the databases to the new servers, if I need to make sure that all the pending transactions from the Replication queue logs are cleared, so that in...
October 1, 2022 at 4:38 pm
This works really well for us, thank you!
Smells like a preamble to SPAM.
October 1, 2022 at 4:37 pm
There is more than 1 plan for a particular query. I suspect it could be auto stats is sampling too low so enabling the persistent sampling. Any thoughts?
It could...
October 1, 2022 at 4:33 pm
A commitment of appreciation is all together for the method, it turned out just immeasurable for me moreover!
Yeah... I'm thinking pre-amble to SPAM here.
October 1, 2022 at 4:30 pm
The first thing to do is to see what login the stored procedure was running under and then look at the settings for the linked server connection to see if...
October 1, 2022 at 4:29 pm
Viewing 15 posts - 2,626 through 2,640 (of 59,067 total)