Recent questions tagged SQL

0 votes

396 views

1 answer

sql - Turning arbitrarily many rows into columns in PostgreSQL

I have a table in Postgres that was designed to capture information in unstructured form and rebuild it. I need ... if that makes it possible. See Question&Answers more detail:os...

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

0 votes

435 views

1 answer

sql - How best execute query in background to not freeze application (.NET)

My WinForm apps needs to execute complex query with significant execution time, I have no influence (about 10mins ... simple execution of that. See Question&Answers more detail:os...

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

0 votes

579 views

1 answer

sql server 2000 - EF code first: Cannot insert explicit value for identity column in table '' when IDENTITY_INSERT is set to OFF

I have issue with EF code first when I am trying to insert new record into table I recieve message. ... HasColumnName("memXMLResponse"); } } See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql server - How to set primary key when linking with CreateTableDef

In a MS Access database, I'm connecting to views in a SQL Server database like this: Dim s As String s ... to reproduce this behaviour in VBA. See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql server 2008 - SQL joining 6 tables

Please take a look at the image.There are 5tables related to appointTable with appointID. Now i need all ... .Appointment.appointment_id='46'; See Question&Answers more detail:os...

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

0 votes

365 views

1 answer

sql - mysql syntax explanation

I would like to know what the a.*, c.name, ... a.access etc means. In other words, what exactly am I referring to ... }" ." AND c.trash = 0" ; See Question&Answers more detail:os...

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

0 votes

521 views

1 answer

sql - MySQL Error Code 1452 Foreign Key Constraint

I'm receiving an error when I attempt to create two tables. There was a multivalued dependency, so I separated the ... in advance for the help. See Question&Answers more detail:os...

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

0 votes

430 views

1 answer

sql - SQLite multiple Autoincrement Columns?

I have the below SQL I am trying to use to create a table and some columns. As part of it, I want ... column as its being inserted? Thank you See Question&Answers more detail:os...

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

0 votes

376 views

1 answer

sql - inserting multiple rows with one insert command

Is it possible to insert more than one row in a table with one insert statement? I know this will happen if ... ) with just one insert command? See Question&Answers more detail:os...

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

0 votes

530 views

1 answer

sql - how to return last inserted (auto incremented) row id in HSQL?

i am working with HSQL database for testing purpose. i want standalone db file. but now i am in trouble to get last ... HSQL. how can i get id?? See Question&Answers more detail:os...

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

0 votes

377 views

1 answer

sql server - uncoditioned Count(*) vs System tables

A collegue of mine show me than, to count a record of a table, the following view: CREATE VIEW [SPR].[ ... in the system tables view solution? See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql - Different ways to alias a column

What is the difference between select empName as EmployeeName from employees versus select EmployeeName = empName ... Appreciate your answers. See Question&Answers more detail:os...

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

0 votes

395 views

1 answer

sql - ORACLE (11.2.0.1.0) - Recursive CTE with a date expression

The right answer on the following question: That is a bug that was fixed in 11.2.0.3 or later if I recall ... ! Screen shots from a real system: See Question&Answers more detail:os...

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

0 votes

408 views

1 answer

sql - Product() aggregate function

While explaining some concepts over CTE, was asked with a cute question.. can we find the multiplication of ... for pure learning experience. See Question&Answers more detail:os...

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

0 votes

389 views

1 answer

sql server - SQL convert 'DDMMYY' to datetime

I am trying to convert a date from DDMMYY format to datetime in SQL Server. I am using the convert command ... . Help will be much appreciated. See Question&Answers more detail:os...

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

0 votes

572 views

1 answer

sql server - Passing SQL stored procedure entirety of WHERE clause

I have a SQL stored procedure of the form SELECT [fields] FROM [table] WHERE @whereSql I want to pass the ... is expected Can this be done? See Question&Answers more detail:os...

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

0 votes

556 views

1 answer

sql - Strip non-numeric characters from a string

I'm currently doing a data conversion project and need to strip all alphabetical characters from a string. ... a once off statement. See Question&Answers more detail:os...

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

0 votes

334 views

1 answer

sql - MySQL Get Time of Old Record Insert?

I have a table in my database which contains all of the users for my application. Unfortunately, when I launched ... Thank you for your time. See Question&Answers more detail:os...

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

0 votes

362 views

1 answer

sql - LINQ OrderBy. Does it always return the same ordered list?

I was trying out a simple OrderBy statement. The target data to order is something like below: [ {"id": ... the exact mechanism under the hood? See Question&Answers more detail:os...

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

0 votes

423 views

1 answer

sql - How to back up a postgresql database from within psql?

I am within psql and am wondering if there is a way to backup/restore databases from this command shell. I have ... at or near pg_dump". Thanks! See Question&Answers more detail:os...

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

0 votes

323 views

1 answer

sql - SELECT COUNT(*) ;

I have a database, database1, with two tables (Table 1, Table2) in it. There are 3 rows in Table1 and 2 ... PRIMARY KEY, NAME NVARCHAR(20) ) See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

sql - How to delete automatically all reference rows if parent row get deleted in mysql?

I have a database which contains around 50 tables. Suppose I have a table named parent with id primary key and ... rows if parent get deleted. See Question&Answers more detail:os...

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

0 votes

407 views

1 answer

sql server - Information schema and Primary Keys

How do I just print out a 'primary key' for the column with the primary key? I get 'primary key' ... = u.table_name ORDER BY table_name See Question&Answers more detail:os...

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

0 votes

399 views

1 answer

sql - INSERT deleted values into a table before DELETE with a DELETE TRIGGER

For some reason I can't find the exact answer that I need. I searched for at last 20 minutes in here ... no Inserted row in the HashTagsArchive See Question&Answers more detail:os...

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

0 votes

451 views

1 answer

sql - How to turn on REGEXP in SQLite3 and Rails 3.1?

I have the following statement in Rails 3 using an SQLite3 database: word = 'Hello' word_entry = Word.where(" ... to MYSQL instead of SQLite3. See Question&Answers more detail:os...

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

0 votes

404 views

1 answer

sql server - Self-referencing constraint in MS SQL

Is it true that MS SQL restrict self-referencing constraints with ON DELETE CASCADE option? I have a table ... there any issue except triggers? See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

sql - MySql "cannot update parent row" when I have "ON UPDATE CASCADE"

So, I am getting: Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails ( ... rows to be updated to 10) See Question&Answers more detail:os...

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

0 votes

483 views

1 answer

sql - How to add a startup script to a mysql docker container?

I started a docker container with mysql. Actually i want to create a new user and a new table - and i have to ... help me here? Thanks a lot! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags