Viewing 15 posts - 31 through 45 (of 59,057 total)
COLUMNS_UPDATED() will tell you which columns had an update attempted but it will not tell you if a value actually changed.
Also, I'm in favor of the clarity of IF UPDATED(CreditLimit)...
August 16, 2025 at 3:31 am
It returned some headers so none of the answers is actually correct.
August 16, 2025 at 3:28 am
Practice SQL interactively, https://www.sql-practice.online/ This is perfect for SQL interview prep. No signup required - just start practicing!
I have Norton Utilities and Global Protect running... one of them didn't...
August 16, 2025 at 3:20 am
For example, if you were planning to use the "Import Data" wizard. That's there in 20, and prior, but not in 21
What on Earth are they thinking?
Lordy...
August 13, 2025 at 2:45 pm
Just to add to the advice - I would advise against SELECT * unless it is absolutely necessary. The reason being if the source metadata changes (column added or...
August 12, 2025 at 10:17 pm
I have to give Steve a huge amount of credit for my success... he's kept this site going and he encouraged me to write articles. This site was also a...
August 9, 2025 at 9:53 pm
However, when the query SELECT * FROM LS01.DB01.dbo.vwA is executed directly on Server B (targeting the linked server), the same operation takes approximately 50 seconds to complete.
We had similar...
August 9, 2025 at 9:25 pm
In some cases, indexes can hurt SELECT performance. .
Do you have a link on that subject?
August 9, 2025 at 3:05 am
Heh... all that and it still left a temporal BETWEEN instead of using the more correct and bullet proof "Closed/Open" comparison method...
...
WHERE soh.OrderDate >=...
July 28, 2025 at 9:15 pm
SELECT SUM([value]) AS [value], {some magic code} FROM [table1]
value is_processed
39.6 Y--===== Because 'Y' is greater than 'N', this works.
SELECT...
July 28, 2025 at 9:03 pm
THIS!!! (from the article)...
Plain language isn’t a lack of sophistication; it’s a sign of mastery.
July 22, 2025 at 3:59 pm
Just a bit of a sidebar... avoid using FORMAT except for maybe 1 row displays. Performance of FORMAT is absolutely horrible even compared to relatively complex CONVERTs. Here's an article...
July 22, 2025 at 3:52 pm
Heh... I'm with ya. My git'up'n'go has got up and went. Hope you had a pleasant weekend, Grant.
July 6, 2025 at 11:08 pm
The missing 5th choice, of course...
"All of them"
Happy Independence Day to all!
July 4, 2025 at 12:08 am
It's not happening to me. I'm not getting the error. I'm also not seeing the "Subscribe" button change to "Unsubscribe" either.
And, as soon as I said that, I hit "Subscribe"...
July 1, 2025 at 5:24 pm
Viewing 15 posts - 31 through 45 (of 59,057 total)