Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql]

Structured Query Language (SQL) is a declarative query language for relational databases. Consider also using the tag for the specific database software if your question involves vendor extensions or language quirks.

0
votes
0answers
27 views

Haw can I execute my VB script in every 5 minutes automatically

I write a VB script and I need to run this script as a trigger in every 5 minutes My code is as follows: Sub Write_data_record_into_a_table() '////////////////////////////////////////////////////////...
3
votes
1answer
279 views

MS Access - Grouped query based on MAX field

I am trying to build a SQL Query that takes the following data: +-------------+--------+---------+---------+--------+ | Primary Key | ID | Version | Class | Fruit? | +-------------+--------+----...
-1
votes
0answers
18 views

SQL - convert letters to numbers [migrated]

I am tasked do convert letter grades (A,B+,D-,...) to numeric gades. A would be 1, B = 2,.. .The + would mean subtracting 0.3 and the - adding 0.3 (e.g. B- = 2.3 and D+ = 3.7) Is there any query to ...
0
votes
1answer
58 views

Connecting DBeaver to a Firebird file, gives error code 335544721

I'm trying to make DBeaver database manager connect to a Firebird *.FDB file. It is a local file database and I want to inspect the tables etc and perform some queries for data reporting. However, ...
0
votes
0answers
43 views

How do I upload an .mdf file to Azure Data Studio for Mac?

How could I access multiple databases at once using Azure Data Studio and import an existing .mdf file as one of those database, with tables and data that had been stored in that .mdf file?
0
votes
0answers
16 views

SQL Compare 13, copy & paste from differences SQL View doesn't copy carriage return/newline?

I'm using SQL Compare 13 to compare a test and production database. Sometimes there are tiny differences and I just copy & paste it from the differences SQL View and run it in the target database. ...
0
votes
1answer
120 views

Jupyter Notebook ModuleNotFoundError --> No module named 'sql' when running Python

I use Jupyter Notebook from Anaconda 3 to run Python but unable to run certain Python code. Below is the first cell of the Python code and the first 2 rows of the error: enter image description here ...
0
votes
0answers
17 views

Access view SQL ad hoc query & output side by side

In MS Access, is there a way to view the sql query window and the related output side by side? I want to be able to write / run sql ad hoc queries and view the output simultaneously so I don't have ...
0
votes
1answer
113 views

How to get rid of Cold Turkey (website-blocker) / get around the block?

I'm using Cold Turkey for blocking distracting websites, but I unfortunately put it to 20 days and it now gets really annoying. Many "solutions" on the internet I have stumbled upon are for Cold ...
0
votes
0answers
49 views

How to install DBATools

I want to install on my Desktop DBAtools utility. I expect that it will help me to explore SQL more .. I found reference to it at this location https://dbatools.io/commands/ I downloaded the package ...
0
votes
0answers
11 views

Export attached(type) files from MS Access to SQL

I want to export database from MS Access database to SQL server. The problem is that when it comes to attached files than sql doesn't recognize it, because there is no such type of data in SQL. I ...
0
votes
0answers
44 views

How to display Oracle SQL code of MATERIALIZED VIEW using DDL command of SqlCl product?

Using Oracle SqlCl tool, when I try to display SQL code of a materialized view using following command DDL mv_address Oracle SqlCl display following message Multiple objects exist with the name ...
0
votes
0answers
74 views

Batch Error SQL Server BULK INSERT

I am attempting to have a script in my batch file that runs a SQL Server Stored Procedure. The Stored Procedure bulk inserts data from a .CSV file into a SQL Server table. When I run the Stored ...
1
vote
0answers
11 views

Intermittent issues connecting to a SQL CE Database

I'm trying to work on a local development copy of a website in Visual Studio 2017. This website uses a SQL CE database in an .MDF file, and I run the site locally through VS using IIS Express. When I ...
0
votes
0answers
43 views

How to do I make NPS properly create its SQL database?

NPS (Windows Server role) natively supports writing authentication logging events to a SQL database. Running through the wizard is supposed to create the database, the table, and the stored procedure(...

15 30 50 per page
 Microsoft office activator |  windows activation crack |  windows product key |  windows 10 product key |  windows 7 ultimate product key |  windows 7 keygen |  activate office 2010 |  office Project keys |  project professional product key |  office 365 office 2016 office 2013 key |  office 2016 office 2013 key |  windows 7 professional product key |  windows 8 professional product key |  windows 10 professional product key |  office 2016 professional product key |