Stack Exchange Network

Stack Exchange network consists of 175 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
5 views

Single update to datetime field correctly updates, update to multiple lines fail

Working in SQL 2014 I created a temp table from a backup db copy of Table 1 with the goal of copying a restored version of ##T2 into T1. When I run: UPDATE T1 SET T1.datetimecolumn = '2019-1-1 00:...
-3
votes
0answers
30 views

Do countries who read right-to-left use more RIGHT JOINs in SQL? [on hold]

I was thinking about how rarely RIGHT JOIN is used in preference of LEFT JOIN due to how much more intuitive LEFT is. I am wondering if this is a product of industry standard, or whether my western-...
0
votes
0answers
6 views

Azure PostGres DB Restore From Dump [on hold]

I took the backup of the current database in Azure PostGres SQL(as .backup file), and trying to restore it on another database. But getting an error as follows: pg_restore:[directory archiver] ...
0
votes
1answer
11 views

Setting SQL Anywhere to Not Cross Join Automatically

In SQLAnywhere when designing queries with the query editor if I accidentally choose a table that cannot be joined to another table except by a cross join SQL Anywhere will automatically create a ...
0
votes
0answers
3 views

Run multiple SQL statements and write results to txt file

I want to run 1900 select statements in the form of the following samples, and I need to collect the results of such statements when the results are not blank or none. SELECT DISTINCT(C_BMESSAGECODE1)...
-2
votes
0answers
11 views

Configuration XAMPP 32 bit and 64 bit in one windows server 2012 R2

ERROR when starting apache and SQL in XAMPP 64 bit 10:49:57 AM [main] Initializing Control Panel 10:49:57 AM [main] Windows Version: Windows Server 2012 R2 64-bit 10:49:57 AM [main] ...
0
votes
0answers
8 views

PostgreSQL IPC MessageQueueSend

I am facing a issue with PostgreSQL 10.4 in CentOS 7. I have a relatively simple query joining two tables that hang for long time in IPC MessageQueueSend state. There's no obvious reason for this ...
-1
votes
0answers
16 views

How to permanently update a Micosoft SQL Server using DBeaver?

I am connecting to a Microsoft SQL Server using DBeaver. I ran an UPDATE command on a table to update all users' login count to 0. After I ran it, I ran a SELECT command and saw that it was indeed ...
0
votes
0answers
7 views

How to use Prepared Statement for Microsoft SQL Xpath queries in java [migrated]

I am having a hard time trying to use Prepared Statement for the below sql xml xpath query in java. SELECT * FROM dbo.EMPLOYEE_DTLS WHERE EMPLOYEE_DTLS.EMP_XML.exist('//emp/empId[text()[1]=?]')= 1 ...
0
votes
0answers
24 views

SQL 2014 Express Failing to Update

Our server has been restarting periodically and I think I've tracked it down to a memory leak in our Solidworks PDM SQL server, after contacting our VAR they said they've encountered this issue and it ...
1
vote
0answers
13 views

Sort Roman numerals in sql server

How to sort Roman numerals in SQL server?
0
votes
1answer
15 views

MySQL one-to-many sub-table join query appears duplicate data

I'm doing a select in MySQL with a three-table join (shown in the lower right quadrant of the below image).  Relevant data in the tables are shown along the left side.  The result is in the upper ...
0
votes
0answers
29 views

Microsoft SQL Server Management Studio not opening

I have been recently using SQL and Microsofts SSMS but had to move from my apartment so I didn't use if for a couple of days. Now when I hit run or run as an administrator on SSMS it shows the loading ...
-3
votes
1answer
56 views

What should I install if server name is empty when trying to connect to server in MSSQL 2014 Management Studio?

I just installed the SQL Server 2014 Management Studio, after this I was trying to connect to server but the rectangle with "server name" was empty and the "browse for more" too: image1 Months ago, I ...
0
votes
0answers
392 views

Ricoh Streamline NX, password reset

Recently, my IT department implemented RICOH STREAMLINE NX V3 for LDAP MANAGEMENT. We changed the password but it doesn't match and I need to reset it. We are using a Windows Server 2012 with IIS ...

15 30 50 per page