|
|
Excellent - that resolved the issue, thanks. Now any chance you can shake a person out of Azure
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
I have discovered that in T-SQL for Sql Server 2022, if I run a stored procedure that happens to call another stored procedure that returns a result set, then the server returns both result sets to my application.
How can I, within T-SQL, specify that the result set of an embedded stored procedure call is not part of the return to the client? Is there a way to specifically choose?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
For a single resultset, you may be able to use INSERT .. EXEC to dump the resultset into a temporary table / table variable.
DECLARE @tmp TABLE ( ... );
INSERT INTO @tmp EXEC yourStoredProcedure ...; But if you control the other stored procedure, a cleaner option would be to add another parameter to suppress the output.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks, Richard. I'm frankly surprised that there's no documented way to return only specific result sets. I'll probably end up using the additional parameter to suppress output.
Cheers.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Is there any tool/solution to export the tables and then data from SQL Server to SQLite?
|
|
|
|
|
|
I know that tools, they simply don't run on my machine. They are C# apps and probably needs some net framework to install. But instead of digging to see why they are not run, I am concentrating to a reliable tool/solution (which I didn't find yet).
|
|
|
|
|
So basically, you've put as much effort into getting the tools you've found to run as you have into asking your question: ie: none.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
No, that's not true. For instance, I have installed a net framework for a C# application, but still doesn't run, so, what can I do? To find out why that application is not working?
modified 25-Jul-24 5:17am.
|
|
|
|
|
_Flaviu wrote: No, that's not true.
I suggest you re-read your own messages, remembering that nobody here can see your screen, access your computer, or read your mind. Do you really think you've put enough effort into describing the problem(s) you're having for someone to be able to help you?
From my perspective, your thread so far reads as:
Summary: I want a tool to do «x».
I've tried some tools - I won't tell you which - and none of them worked, probably because I didn't read the system requirements or install the prerequisites.
Rather than trying to fix the errors, or tell you what the errors are and ask for help with fixing them, I've added those tools to a secret shitlist of "unreliable tools".
I now demand that someone provide me with a tool that isn't on my secret shitlist - and no, I won't tell you what's on it! - that works first time, with zero effort on my part.
Remember, the effort someone is going to put into answering your question is directly related to the effort you put into asking it. If we have to keep dragging tiny snippets of information out of you in dribs and drabs, then why should we bother trying to help?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
I have succeeded to migrate a table from SQL Server by importing it the table to Excel, and from Excel sheet to SQLite using Python. The relations between tables I guess I should do it manually.
|
|
|
|
|
Insufficient key column information for updating or refreshing problems is displayed
|
|
|
|
|
|
Aside from the fact that you're still using software which is a whole quarter of a century out-of-date, and has been officially "dead" for over two decades, you haven't provided any information that could be used to help you.
Rather than giving us your "summary" of the error message, provide the full error message, and explain precisely what you were doing when you saw it. If it's cause by code, then show the relevant parts of your code.
You also need to explain what you have tried and where you are stuck.
With the limited information provided, the only "help" we can offer is to paste your error into a search engine.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: Aside from the fact that you're still using software which is a whole quarter of a century out-of-date,
Just noting that VB6 is still 'good' at least through EOL for Windows 11. Won't be improved but it won't stop working either.
Support Statement for Visual Basic 6.0 | Microsoft Learn[^]
|
|
|
|
|
By that argument, maybe we should all start our next projects in COBOL?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: all start our next projects in COBOL?
To be fair COBOL has new spec in 2023 and one can create AWS Lambdas with it also.
So perhaps Pascal is a better comparison?
|
|
|
|
|
Then ALGOL-60 would be much better!
|
|
|
|
|
jschell wrote: Just noting that VB6 is still 'good'
And that's when the violent vomiting started.
|
|
|
|
|
"Good enough for government work" - especially up here in North Yorkshire[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Confirming the speed and mentality of government!
|
|
|
|
|
I'm doing some development in SQLite and I have data, specifically databases a la Mozilla (the Firefox front office complex) but in order to clear my browser history, something that I think will happen automatically if I dare upgrade/update, my cache of "data" will be destroyed and all my bookmarks will be lost as well as my extensive history.
Whether I'm right about the loss happening when I do anything to the current browser or not, does anyone know if an update will fix the SQLite functionality used by the mozilla implementation, specifically whether the "unixepoch" date/time function which was introduced around 2022 will be at my disposal?
[EDIT]
"DB Browser for SQLite" tells my it's using SQLite v.3.27.2 and "unixepoch" is not there yet.
[END EDIT]
modified 6-May-24 15:04pm.
|
|
|
|
|
Not sure how relevant this is to your situation, but here's my 2¢:
Firefox browser is normally very good at preserving bookmarks, history, etc over software updates. I have some that are many years old having survived tens of upgrades.
(btw the current Firefox is about 125.something, so 72 is waaay behind.
Also its storage of such things is neatly tucked away in a profile folder (location is OS-dependent), so you can always squirrel away a copy of that folder.
And you do have a current backup of everything relevant, of course.
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|