Viewing 15 posts - 91 through 105 (of 55,829 total)
Have you actually had to do such a thing where you work?
June 6, 2022 at 10:50 pm
Does the table actually exist and you're just checking to see if the column exists or will the table actually be missing?
In either case, I'm pretty sure that you're going...
June 6, 2022 at 10:47 pm
Here's the code to get the two values as separate integers. I've also included code to concatenate them as a string. I still don't believe that joining them together is...
June 6, 2022 at 10:35 pm
I take it that the zero's between the two obvious parts could be consumed by an increasing value of the right part or will it ALWAYS be 7 digits (no...
June 6, 2022 at 8:37 pm
One area where it seems XML is required is for the conversion/encoding of strings to varbinary base 64. Altho if there's newer way I'd be interested to hear about...
June 6, 2022 at 8:15 pm
found the answer
https://stackoverflow.com/questions/18010850/sql-with-clause-within-a-with-clause
Happy coding!
Can you post the solution for the code you posted?
June 6, 2022 at 5:50 pm
I'm learning xml. I'm getting the hang of the nitty gritty, tags, elements, etc. I haven't come across the WHY except that it's "good for sharing across platforms." So...
June 6, 2022 at 5:18 pm
@scott... the comment about "magic" wasn't meant as a slam to you. It was meant as a slam to MS because they claim that you can do minimal...
June 6, 2022 at 5:03 pm
There's gotta be a way to read the manifest of files from a zip file in SSMS. Almost everything else has that capability.
Not sure what you are getting...
June 6, 2022 at 5:09 am
Apologies on the mistake about COMPRESS.
I know you think that 2016 is magic after the first insert. The documentation says that new pages will be minimally logged. I'll have to...
June 6, 2022 at 5:07 am
Thanks for your responses,
We have more sorts and joins.
Thank you
A lot of that can be resolved by indexes in most cases. In some cases, the indexes won't actually be...
June 6, 2022 at 5:02 am
Hello everyone!
I'm a beginner with databases and I'm getting started with building a front end for my database so that end users can add/edit data. I've been trying to...
June 5, 2022 at 5:37 am
Or how does the REBUILD over there interact with action thats happening on the server? from what ive been told its a very active table even at night when...
June 5, 2022 at 5:30 am
I'd also suggest using OPENQUERY instead of just EXECUTE. Or, like you said, EXECUTE AT.
June 5, 2022 at 5:16 am
There's gotta be a way to read the manifest of files from a zip file in SSMS. Almost everything else has that capability.
June 5, 2022 at 5:08 am
Viewing 15 posts - 91 through 105 (of 55,829 total)