Recent questions tagged sql

0 votes

313 views

1 answer

sql server - SQL query on multiple databases

I have two databases on one sql server, and I have to link two tables from one DB server to two tables in ... CHMD' OR CG.TASK_CODE ='CHSN') See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

438 views

1 answer

sql - How to find all open/active connections in DB2 (8.x)

I'm currently working with Db2 Enterprise Server V 8.2 with FixPak 10 And I want to retrieve list of all the ... DB2? Thanks in advance, Kamal See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

426 views

1 answer

sql server - Whats wrong with this SQL statement for table variable bulk insert

I'm trying to insert a CSV into a Temporary table and this SQL statement doesn't seem to work. DECLARE ... Incorrect syntax near '@TempTable'. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

376 views

1 answer

sql - Access DB update one table with value from another

I'm trying to update all records in one table with the values found in another table. I've tried many ... still getting the same error though. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

359 views

1 answer

sql - Problem with MySql INSERT MAX()+1

I have a single table containing many users. In that table I have column called user_id (INT), which I want increment ... to start from 1 not 0. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

483 views

1 answer

sql - postgres column alias problem

As a newbie to Postgresql (I'm moving over because I'm moving my site to heroku who only support it, I'm ... the queries worked fine in mySql... See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

242 views

1 answer

sql - SparkSQL error Table Not Found

I converted an RDD[myClass] to dataframe and then register it as an SQL table my_rdd.toDF().registerTempTable(" ... Thread.run(Thread.java:745) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

300 views

1 answer

sql - How to Delete Records NOT IN

Hi I have the following SQL Query which gives me Scheme_Id which exist both in ProjectSchemes and Schemes table. ... s.Scheme_Id=ps.Scheme_Id) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

482 views

1 answer

sql - Is it better to do an equi join in the from clause or where clause

When joining two simple tables on primary key columns and placing an addition equality condition this can be done in the ... A.DURATION = 3.00 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

335 views

1 answer

sql - Extract characters to the right of a delimited value in a SELECT statement

I need to extract all the characters to the right of a hyphen as part of a select statement. There will be ... I am using SQL Server 2008. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

414 views

1 answer

sql - How to get the date and time from timestamp in PostgreSQL select query?

How to get the date and time only up to minutes, not seconds, from timestamp in PostgreSQL. I need date as ... select query. Please help me. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

462 views

1 answer

sql server - "Specified cast is not valid" error in C# windows forms program

I'm having a "Specified cast is not valid" error. Windows form application in C#. I'm trying to retrieve a ... quantity"]; // error is here See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

363 views

1 answer

sql - Insert multiple rows in SQLite

I am trying to insert multiple rows in a SQLite (latest version) table but throws an error got the idea from ... help would be appreciated. TIA See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

594 views

1 answer

sql - What timezone does MySQL's NOW() follow

Does MySQL's NOW() follow the system's timezone or some standard like GMT or UTC? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

389 views

1 answer

sql - Multiple NOT distinct

I've got an MS access database and I would need to create an SQL query that allows me to select all the not ... that I need. Any help? Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

299 views

1 answer

sql - How to find which columns don't have any data (all values are NULL)?

I have several tables in a database. I would like to find which columns (in which tables) don't have any ... all select 2 union all select 3 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

279 views

1 answer

sql server - Behavior of unique index, varchar column and (blank) spaces

I'm using Microsoft SQL Server 2008 R2 (with latest service pack/patches) and the database collation is ... would be appreciated. Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

300 views

1 answer

sql server - Cannot persist computed column - not deterministic

I have this function for a computed column : CREATE FUNCTION [dbo].[GetAllocatedStartTime](@Year INT, @Week INT) ... what I have just said. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

885 views

1 answer

sql - How to convert time in seconds to HH:MM:SS format in MySQL?

I'm having a data column named test_duration bigint(12). I'm storing time in seconds into the database. Now ... achieve this? Thanks in advance. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

427 views

1 answer

sql server - SQL can I have a "conditionally unique" constraint on a table?

I've had this come up a couple times in my career, and none of my local peers seems to be able ... just academically interested in the problem. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

351 views

1 answer

sql - Why does conversion from DATETIME to DATETIME2 appear to change value?

I had a stored procedure comparing two dates. From the logic of my application, I expected them to be equal. ... is smaller but still not zero: See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

519 views

1 answer

sql - Oracle trim whitespace on the inside of a string

I am storing phone numbers as VARCHAR2 in my system to allow for users to input '+' characters infront ... would be greatly appreciated. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

429 views

1 answer

sql - Creating a CTE in Oracle

I am trying to create a CTE in Oracle that doesn't select from an existing table but instead has data inserted into it. ... 31', 'yyyy-mm-dd')); See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

789 views

1 answer

sql - How to check if trigger exists in PostgreSQL?

I want to verify correctness of database migrations which add triggers to some tables. I'm using sqitch, so I'd like ... find a way to do this. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

292 views

1 answer

sql server - Issues with T-SQL TRY CATCH?

We are currently on SQL 2005 at work and I am migrating an old Foxpro system to new web application backed by ... input you may wish to provide. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

355 views

1 answer

sql server - How to loop through all SQL tables?

We have a piece of software that does not delete entries we no longer want. In order to get a feel for how ... loop through all of the tables? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

309 views

1 answer

sql - C# stored procedure with parameters

I am receiving an error in my application and i can not figure out how to resolve it. Here is the code: ... be much appreciated. Thanks, Matt See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

408 views

1 answer

sql - "Save changes is not permitted" when changing an existing column to be nullable

I've got a SQL Database Table, which has 35 existing records. One of the fields in this table is called ... be dropped and re-created? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags