Viewing 15 posts - 3,541 through 3,555 (of 59,067 total)
Again, I'd like to know why we're perverting email addresses in such a fashion. There has to be a reason.
April 29, 2022 at 7:49 pm
Hi Thom
First i get data saved in Temp table like below
CodeNameQuantityDscription
32Rohan1 Item 1
32Rohan2 ...
April 29, 2022 at 7:44 pm
Some real or better-simulated data for the file is absolutely necessary for us to help you here or the answer will be either to create a BCP format file or...
April 29, 2022 at 5:55 pm
To go along with what Scott stated, when is the last time you rebuilt statistics on the date column? How many rows have been changed according to the modification_counter column...
April 29, 2022 at 5:50 pm
How to remove integers from the Email Id
Please guide
WHY???? It seems to me that you're removing a necessary part of a correct email address. 🙁
April 29, 2022 at 5:02 pm
I have the same concerns about a PoSh script as I do with an SQLCMD script.
April 29, 2022 at 4:56 pm
I'll say, Absolutely. It's a very necessary form of communication no matter what you do in life but especially in the world of IT. And, it's not limited to just...
April 28, 2022 at 10:47 pm
I REALLY enjoyed the "Programming Sucks" article you provided a link to, Steve. The funniest part about it is that it's all true! 😀
Shifting gears a bit, thank you for...
April 28, 2022 at 10:15 pm
Oh bless you, Scott Pletcher, this works wonderfully.
I have a question just out of curiosity... what are you going to do with the zeroes once you have the correct...
April 28, 2022 at 4:16 am
There are actually several massive differences between Truncate and Delete. You can read about most of them simply by looking up the commands and reading about them.
One not so well...
April 28, 2022 at 3:45 am
It sounds like a "connection leak" built in. Either that or connection pooling on steroids that has gotten a bit out of hand and forgetting to deallocate a cursor or...
April 27, 2022 at 5:06 pm
BWAAA-HAAA-HAAA! 😀 NCHAR(MAX). I wonder if anyone will bite on that. 😀
April 27, 2022 at 12:30 am
I don't know and I actually try to avoid all forms of "replication" but posting your question to Google came up with this. They have a link at the bottom...
April 27, 2022 at 12:12 am
Are you just trying to LPAD zeros for a total length of 5? If so, this will make your life easier...
DECLARE @SomeInt INT = 22;
SELECT RIGHT(CONCAT('00000',@SomeInt),5)
;
Note...
April 27, 2022 at 12:05 am
Doesn't matter... sounds like you need more RAM for whatever you having the server do either way.
April 26, 2022 at 7:03 pm
Viewing 15 posts - 3,541 through 3,555 (of 59,067 total)