Database Discussion Boards

HOW TO ANSWER A QUESTION

Chris Maunder16-Jul-09 3:10

Chris Maunder

16-Jul-09 3:10

Apologies for the shouting but this is important.

When answering a question please:

Read the question carefully
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar
If a question is poorly phrased then either ask for clarification, ignore it, or mark it down. Insults are not welcome
If the question is inappropriate then click the 'vote to remove message' button

Insults, slap-downs and sarcasm aren't welcome. Let's work to help developers, not make them feel stupid.

cheers,
Chris Maunder

The Code Project Co-founder
Microsoft C++ MVP

How to get an answer to your question

Chris Maunder10-Nov-05 16:30

Chris Maunder

10-Nov-05 16:30

For those new to message boards please try to follow a few simple rules when posting your question.

Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
Keep the subject line brief, but descriptive. eg "File Serialization problem"
Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
No advertising or soliciting.
We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.

cheers,
Chris Maunder

The Code Project Co-founder

Microsoft C++ MVP

Alternative to SQLite or MSAccess

lucausa756-Oct-24 2:07

lucausa75

6-Oct-24 2:07

Any alternative to SQLite?
I'm using an MSAccess database which uses a file to stoee all the data. I found SQLite which is using a file as database.
The issue with SQLite is the missing way to protect this database with a password.
That's why I need something similar to SQLite or MSAccess: does anyone know any alternative? What about firebird?
Thanks

modified 4 days ago.

Re: Alternative to SQLite or MSAccesd

Victor Nijegorodov6-Oct-24 5:43

Victor Nijegorodov

6-Oct-24 5:43

MS SQL Server Express Edition

Re: Alternative to SQLite or MSAccess

lucausa756-Oct-24 11:35

lucausa75

6-Oct-24 11:35

Does MS SQL Server Express Edition create the database in a single file like MSAccess?

modified 4 days ago.

Re: Alternative to SQLite or MSAccesd

Victor Nijegorodov6-Oct-24 20:01

Victor Nijegorodov

6-Oct-24 20:01

SQL Server creates two files for each DB: Microsoft SQL Server Database Files & Internal Structure

Re: Alternative to SQLite or MSAccess

lucausa756-Oct-24 21:18

lucausa75

6-Oct-24 21:18

Can I copy those two files in a different PC or directory in order to continue to use it?
My idea is creating the database in PC A and move those files in a dedicated directory of PC B

Re: Alternative to SQLite or MSAccess

Victor Nijegorodov6-Oct-24 22:19

Victor Nijegorodov

6-Oct-24 22:19

Probably.
However, the best way would be to backup the DB on the PC A and then restore it on PC B.

Re: Alternative to SQLite or MSAccesd

k50546-Oct-24 6:04

k5054

6-Oct-24 6:04

Is this not useful? SQLite Encryption Extension: Documentation

"A little song, a little dance, a little seltzer down your pants"
Chuckles the clown

What's the syntax error?

Richard Andrew x6427-Sep-24 8:21

Richard Andrew x64

27-Sep-24 8:21

What's the syntax error in the following TSQL stored procedure call?

SQL

EXEC StoredProcedureName 9,'723147504','1',CONVERT(DATETIME, '09-27-2024 14:14:28'),'calculated','','','',0,0,0,0,0,0,0,0;

SSMS is telling me "Syntax error near keyword CONVERT"

The difficult we do right away...
...the impossible takes slightly longer.

Re: What's the syntax error?

Ron Nicholson27-Sep-24 8:44

Ron Nicholson

27-Sep-24 8:44

I typed it in as a Select and it worked fine. Changing it to and EXEC proc failed. Try converting the date then see.

SQL

DECLARE @DateT DateTime = Convert(DateTime, '09-09-2024 14:14:28')
EXEC StoredProcName 9,'12341239487','1', @DateT,'calculated','','','',0,0,0,0,0,0,0,0,0;

This works fine for me. Raiserror is the same way, can't cast or convert inline.

Jack of all trades, master of none, though often times better than master of one.

Re: What's the syntax error?

Richard Andrew x6427-Sep-24 9:23

Richard Andrew x64

27-Sep-24 9:23

Thanks, Ron. I guess it's not a huge problem, but it is annoying!

The difficult we do right away...
...the impossible takes slightly longer.

Re: What's the syntax error?

jschell27-Sep-24 12:44

jschell

27-Sep-24 12:44

Interesting. Not a new problem apparently

https://stackoverflow.com/questions/5967035/using-function-as-a-parameter-when-executing-a-stored-procedure[^]

Re: What's the syntax error?

Richard Deeming30-Sep-24 21:40

Richard Deeming

30-Sep-24 21:40

If the parameter is typed as datetime, you shouldn't need to explicitly convert the string literal when you pass it in.

However, it would probably be best to use the unambiguous date format (yyyyMMdd):

SQL

EXEC StoredProcedureName 9, '723147504', '1', '20240927 14:14:28', 'calculated', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0;

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: What's the syntax error?

Richard Andrew x641-Oct-24 13:02

Richard Andrew x64

1-Oct-24 13:02

I'll give this a try when I'm back in my office.

The difficult we do right away...
...the impossible takes slightly longer.

SQL Server Permissions

Richard Andrew x6422-Aug-24 10:32

Richard Andrew x64

22-Aug-24 10:32

If I give read-only access to a SQL Server login, does that mean they cannot call stored procedures that CRUD data?

What I'm looking for is the ability for users to:

1. Read the database,
2. Execute stored procedures that CRUD data.

But NOT run any DDL. Meaning they cannot change table structures or stored procedures.

I'm sure there must be a way to configure this.

The difficult we do right away...
...the impossible takes slightly longer.

Re: SQL Server Permissions

Richard Deeming22-Aug-24 21:25

Richard Deeming

22-Aug-24 21:25

So long as the user has permission to execute the stored procedure, and the stored procedure and the tables it references have the same owner, then it will work even if the user doesn't have any permissions on the referenced tables.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: SQL Server Permissions

Richard Andrew x6423-Aug-24 5:05

Richard Andrew x64

23-Aug-24 5:05

Thanks, Richard!

The difficult we do right away...
...the impossible takes slightly longer.

SQL Server downloads and msoledbsql

Mycroft Holmes6-Aug-24 12:38

Mycroft Holmes

6-Aug-24 12:38

Attempting to recover from the Azure disaster I downloaded the developer and then the express versions of SQL Server 22. Both failed to install because of a missing/incorrect msoledbsql. I then downloaded the dll and installed it before attempting to reinstall, it still failed on the same issue.

I tried the same with 2019 version with the same issue.

Any suggestions as to how to get around the problem?

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

Re: SQL Server downloads and msoledbsql

jschell8-Aug-24 12:45

jschell

8-Aug-24 12:45

Google?

This one seemed encouraging.

https://stackoverflow.com/questions/71857345/error-when-installing-microsoft-sql-server-2019-cannot-find-the-microsoft-ole-d[^]

Re: SQL Server downloads and msoledbsql

Mycroft Holmes8-Aug-24 13:11

Mycroft Holmes

8-Aug-24 13:11

Excellent - that resolved the issue, thanks. Now any chance you can shake a person out of Azure Laugh | :laugh:

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

How to ignore and not return result sets

Richard Andrew x6427-Jul-24 8:09

Richard Andrew x64

27-Jul-24 8:09

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.

Re: How to ignore and not return result sets

Richard Deeming28-Jul-24 21:29

Richard Deeming

28-Jul-24 21:29

For a single resultset, you may be able to use INSERT .. EXEC to dump the resultset into a temporary table / table variable.

SQL

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

Re: How to ignore and not return result sets

Richard Andrew x6429-Jul-24 9:00

Richard Andrew x64

29-Jul-24 9:00

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.

Migrate structure and data from SQL Server to SQLite

_Flaviu24-Jul-24 5:11

_Flaviu

24-Jul-24 5:11

Is there any tool/solution to export the tables and then data from SQL Server to SQLite?

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.