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
6 views

SQL Server 2012 Job Seemingly not running at all, manual or scheduled, no logs

We recently installed a side-by-side instance of SQL Server 2017 on our DEV environment, and almost all of our DBs and jobs have migrated over. However due to compatibility issue, we still have a ...
1
vote
1answer
15 views

SQL Sever Management Studio 2008 does not let me back up my database

I tried to back up a server I created in SQL Server, but I received the following message: TITLE: Microsoft SQL Server Management Studio Backup failed for Server 'LAPTOP-6D0L83DV\SQLEXPRESS'. ...
0
votes
0answers
12 views

I am using DBeaver and go the error 'FATAL: database “postgres” does not exist'

I was using DBeaver and all of the sudden, I could no longer access my previous PostgreSQL databases or create new ones. I got the error 'FATAL: database "postgres" does not exist' when trying to open ...
1
vote
0answers
12 views

How to determine when SQL Server Express is not enough

My web server is using SQL Server Express edition with multiple databases serving multiple websites and perhaps 100 simultaneous users at any given moment. Memory usage seems to always be near 1 GB (...
0
votes
0answers
18 views

Error message: couldn't open firebird database, check your path / When trying to open Java application

I have problems opening up the Java application I am currently developing in NetBeans. The project has no errors in the code and I have double checked that I am connected to my database, I am using ...
0
votes
0answers
12 views

Access SQL Subquery to find a value from the previous year record (Max/Top minus 1)

All the advice I was able to locate doesn't seem to get at this (I am also trying to avoid a DLookup in the Table itself): The table: Table has client records including a Year field, an ...
0
votes
0answers
11 views

Can Redshift save off or quarantine bad records on import?

In the following command, 90 records import successfully, and two records fail: user@host:~$ psql --host=redshiftcluster.amazonaws.com --username=user --dbname=dev --port=5439 -c "COPY tmp_table FROM ...
0
votes
0answers
7 views

woo-commerce: place an order to a different database [closed]

Here is my situation, I have an ecommerce website built with woocommerce on wordpress Hosted on Godaddy PHP server . I also have an Asp.Net MVC application that I developed that will serve other ...
-2
votes
0answers
21 views

SQL service not run in win 10 or win server 2016 startup

SQL service not run in win 10 or win server 2016 startup I've tried with auto-delay and other Option but it won't work correct.
-1
votes
0answers
29 views

Unable to connect to specified MySQL host error when trying to use a exe

I've recently purchases a tool for xbox 360 and for some reason whenever i try signing into the program i get this error See the end of this message for details on invoking just-in-time (JIT) ...
0
votes
0answers
10 views

Personalized login / Hide information [closed]

A cordial greeting, I would like to make a personalized login where the User (nvarchar (50)) can ONLY see the rows that contain his name and the Administrator sees everything. My table in SQL CREATE ...
0
votes
0answers
6 views

Create report generate error 80070002 in vb.net 2010

I installed SAP crystal report and changed my framework to .netframework 4, also choosed the crystal report 13 fro the choose items. Stillwhen i try to create a new report, it shows the "system cannot ...
0
votes
1answer
13 views

How to make SQL Server return records that fall within any one of many time (or any value really) ranges defined in a separate table?

The code below clarifies the question in the title. What can be put in the WHERE to make it work? CREATE TABLE #PickedTimes (StartTime smalldatetime, EndTime smalldatetime) INSERT INTO #PickedTimes ...
0
votes
0answers
10 views

new user password disappear after I create in SQLdeveloper

I have problem when I create new user so the password disappear after I create in SQL developer and when I tried to make connection its giving errors please help.
1
vote
2answers
20 views

How to I establish CODEUNIT32 (CHAR SET = “UTF-32” in DDL?

I am trying to model a request for a column that will be VARCHAR(120), but will actually store 480 bytes. The length of 480 is established as VARCHAR (120) = 120 x 4 = 480 bytes. This is due to ...

15 30 50 per page