Viewing 15 posts - 1,471 through 1,485 (of 8,731 total)
March 15, 2017 at 12:38 pm
I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html
It had exactly what I was looking for and the style seemed familiar....
March 15, 2017 at 12:32 pm
March 15, 2017 at 12:28 pm
SELECT @Var += SomeExpresion FROM SomeTable;
is a shortcut to
SELECT @Var = @Var +SomeExpresion FROM SomeTable;
This is a common shortcut in many programming languages. I learned it...
March 15, 2017 at 12:17 pm
Here's an alternative version because it seems that your numbers are not digit-only.UPDATE Inventory
SET ItemNum = SUBSTRING(ItemNum, PATINDEX('%[^0]%',ItemNum), 4000)
WHERE ItemNum like '0%'
March 15, 2017 at 12:10 pm
Instead of using exec (@fullFiles), use: PRINT @fullFiles
Then copy the code from the messages tab and find where you need to fix your quotes. You have some missing quotes...
March 15, 2017 at 6:04 am
We have a field in a table that's a string-valued field. In this field...
March 14, 2017 at 10:55 am
March 14, 2017 at 10:49 am
March 14, 2017 at 10:44 am
I'll be extremely happy the day that JC admits he's wrong in a forum post. Every time he's proven wrong, he just avoids the subject and posts more unrelated nonsense....
March 13, 2017 at 4:17 pm
I've seen the behavior and it's mostly a display refresh issue. I usually fix it by scrolling the query.
Remember that even if you have a good computer, SSMS is...
March 13, 2017 at 4:11 pm
March 13, 2017 at 10:27 am
Viewing 15 posts - 1,471 through 1,485 (of 8,731 total)