Viewing 15 posts - 106 through 120 (of 5,101 total)
But what about this? It returns null in both cases....
declare @t int
select case when @t is null then @t else null end
The error specifically states it can't be a...
January 23, 2023 at 9:52 am
Also, to support Thom on his claim that 3 and 4 part naming has been deprecated, take a look at the following article written by a really smart fellow...
January 23, 2023 at 9:01 am
I disagree about aliasing because I don't see the point except when a table is JOINed more than once in the same statement.
I used to be on this...
January 20, 2023 at 4:39 pm
3+ part naming for columns is (due to be) deprecated, so get out of the habit of their style. Instead, alias the object(s) in your FROM and then qualify the...
January 20, 2023 at 4:26 pm
I think the topic is "bugged"... I got a notification of a response from Scott, and the forum shows they were the last to reply, but I don't see it......
January 20, 2023 at 4:22 pm
If "Time" were the first in order in the index, that would be much better?
Like Jo said, I wouldn't just go changing your clustered index without considering the effect...
January 20, 2023 at 10:40 am
"Time" is part of the clustered index, but the clustered index, as stated in the first post, consists of total of 4 columns (bigint, int, varchar(255), datetime, in that...
January 20, 2023 at 10:34 am
So do you have index on Time ? Does it contain any other columns and INCLUDE the rest of the columns in the SELECT? Without the query, DDL of the...
January 20, 2023 at 10:08 am
Are you able to share the execution plan (Paste the Plan)? This'll help us understand what the RDBMS is up to, and see if there are any helpful indexes....
January 20, 2023 at 9:38 am
how can i change the language setting of the login/user?
ALTER LOGIN YourLogin WITH DEFAULT_LANGUAGE = BRITISH;
Obviously changing the name of the LOGIN and language you need...
October 24, 2022 at 1:45 pm
Thom A wrote:Have you tried using an unambiguous date format?
'2021-11-01 00:00:00.000'is ambiguous withdatetime. Try'2021-11-01T00:00:00.000'or just'20211101'.Well spotted!
Not being American teaches you quickly that the format...
October 24, 2022 at 1:07 pm
Have you tried using an unambiguous date format? '2021-11-01 00:00:00.000' is ambiguous with datetime. Try '2021-11-01T00:00:00.000' or just '20211101'.
October 24, 2022 at 12:48 pm
The documentation you've link is for the Find (and Replace) tool, is that what you are using? I admit, :b does not work for me for tabs or spaces either,...
September 15, 2022 at 3:30 pm
Thanks!
Thom A wrote:but I'm not a massive fan of such things.
Can you please specify? Are there any pitfalls when I use it
Pitfuls? A couple would be how to maintain it...
September 15, 2022 at 10:45 am
Viewing 15 posts - 106 through 120 (of 5,101 total)