3

Since MS Access can save a query in the database file I assume there is a way to do this programmatically from C#. Any idea how?

Improve this question
3
  • What do you mean by "Save a Query"? Save the SQL that you sent to the database, then run it later? Commented Jun 26, 2013 at 16:38
  • Yes. In MS Access for instance you have a list of tables and a list of queries. These queries can only be stored in the database file since when you close it and re open it they're still there. Commented Jun 26, 2013 at 16:42
  • you find it or not yet ?? @Juan Commented Jul 20, 2020 at 19:03

1 Answer 1

Reset to default
0

Looks like it's not possible. SQL Server doesn't record queries, according to This (Not sure about other databases, but I imagine they all work the same way)

You'd need to manually store them as a varchar in a table

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

But then how do you explain MS Access storing queries in the database file? SQL Server is different than the JET Engine.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.