Recent questions tagged database

0 votes

624 views

1 answer

database - MySQL server stored procedure syntax error

I am having some trouble with creating a Stored Procedure for a MySQL database. Here is a Select statement that works: use canningi_db_person_cdtest; SELECT * ... return a result set in the given context See Question&Answers more detail:os...

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

0 votes

639 views

1 answer

database - Returning a value from an INSERT statement in SQL Server 2008

Database : SQL Server 2008 Is there a way to have an insert statement return a value in SQL Server, There is a similar question in Return a value from ... a stored procedure, I want a SQL statement only . See Question&Answers more detail:os...

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

0 votes

618 views

1 answer

database - how to pass values dynamically in config file

I want to pass the value in the value tag of the property dynamically from the DB. Is this possible in Spring? And how ? For example in the ... to be taken from the DB and passed here dynamically. See Question&Answers more detail:os...

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

0 votes

725 views

1 answer

database - Mysql Chain Select Query

I have a database with a table which looks somewhat like this : Root | Connector A | B B | C C | D D | E E | - So i want to retrieve the ... means C->D->E I am using mysql database. Thanks in advance See Question&Answers more detail:os...

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

0 votes

744 views

1 answer

database - Find the parameter names of a stored procedure

I am using Microsoft SQL Server 2008. I have a stored procedure. Is there a simple query I can execute that will give me the parameter names? I have ... Link but it is not for Microsoft SQL Server 2008. See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

database - LINQ to SQL for self-referencing tables?

I have a self referencing Categories table. Each Category has a CategoryID, ParentCategoryID, CategoryName, etc. And each category can have any number of ... it better to used a Stored Procedure instead? See Question&Answers more detail:os...

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

0 votes

638 views

1 answer

database - Linq to SQL error : An order by expression can only contain non-constant scalars

I'm using a GridView and a LinqDataSource to view the Categories table. I set the Gridview to enable sorting. Sorting generally works except when i ... does NText is not sortable when nvarchar are? See Question&Answers more detail:os...

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

0 votes

576 views

1 answer

database - java jdbc accessing multiple resultsets

I have the following structure: List -->List_Participant -->Participant so a list may contain several participants.I try to read this in java: stat = con ... now, since they might have the same name? See Question&Answers more detail:os...

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

0 votes

466 views

1 answer

database - crosstab: Counting the same string in a field and display it as field name

I would like to have a total of specific string in the field, for this example in the PAYROLL_PAYMONTH field. For example, I will count the number of 'HELLO' ... is not the result I want. What to do next? See Question&Answers more detail:os...

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

0 votes

577 views

1 answer

database - GETUTCDATE() and Time Zone (SQL Server)

I want to add my time zone with the function GETUTCDATE() in SQL Server. I searched several times, but did not found any relevant solution. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

database - How rotate sql result entries into columns (pivot)

I have table a | id | value | comment | |--------------------------| | 1 | Some1 | comm1 | |--------------------------| ... it as a flat result to use it for reporting... Is it possible at all? thanks See Question&Answers more detail:os...

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

0 votes

627 views

1 answer

database - How to fix possible db corruption?

I'm at a client doing some quick fixes to their access application. It was a while I had a go with access, but I'm recovering quickly. However, I ... , since it pointed me in the right direction. Thanks! See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

database - PostgreSQL: could not connect to server - Connection refused error

I've failed to set up postgreSQL to work with my Ruby-on-Rails project for the past week. I've tried to uninstall and reinstall, postgreSQL, twice ... . Does anyone have any suggestions for me? Thanks! See Question&Answers more detail:os...

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

0 votes

734 views

1 answer

database - Copy Access table structure and constraints using C# or SQL

Can someone tell me how to copy an MS Access table's table structure and all its constraints, keys, and etc. using .NET or SQL? I have searched ... can find a way. Any tips would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

620 views

1 answer

database - How to return column that matched the query in Solr..?

I am using apache Solr for searching my database..!! Suppose i have indexed 4 columns from one of my table..!!..I just want that only those columns that ... other columns..!! How can i acheive this..?? See Question&Answers more detail:os...

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

0 votes

728 views

1 answer

database design - Cassandra - one big table vs many tables

I'm currently looking trying out Cassandra database. I'm using DataStax Dev center and DataStax C# driver. My Current model is quite simple and consists of ... I be able to range query on my MeasureTime? See Question&Answers more detail:os...

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

0 votes

692 views

1 answer

database - anonymous read with amazon simpledb

I would like to query simpledb directly from the client using javascript. My application is read-heavy and I rather not route the request through ... solutions (microsoft, google) have this functionality? See Question&Answers more detail:os...

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

0 votes

603 views

1 answer

database - Sql query to create a calculated field

I have a database table like this: I hope I can explain this well, so you can understand. I want to calculate how many hours each employee has ... not DateTime. I am working with MS Access Database. See Question&Answers more detail:os...

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

0 votes

982 views

1 answer

database - How display images in datagridview? c#

I am developing an application in C # for desktop using Visual Studio Express 2010. I have a table in MySQL called Products with 3 fields: ID -> ... fill datagrid with ID, product name, product image } See Question&Answers more detail:os...

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

0 votes

590 views

1 answer

database - Find a table when you know the name of a column?

I have a DB in Access with an incredible amount of tables. Unfortunately, the creator used very non-descriptive names, so it's basically impossible to even ... I start going one-by-one like a monkey? See Question&Answers more detail:os...

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

0 votes

788 views

1 answer

database - Intellij ERROR: No suitable driver found for jdbc:mysql://127.0.0.1:3306/person

first of all I couldn't find an answer from related questions in this forum. I am new to Hibernate technology and I am trying to run a ... Mysql database has been made through Wampservers' phpmyadmin. See Question&Answers more detail:os...

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

0 votes

515 views

1 answer

database - What is the performance difference in MySQL relational division (IN AND instead of IN OR) implementations?

Because MySQL does not have a built in relational division operator, programmers must implement their own. There are two leading examples of implementations ... which one would offer the best performance? See Question&Answers more detail:os...

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

0 votes

655 views

1 answer

database - To improve SQL-queries in DDL

Improvements done nvarchar(5000) -> nvarchar(4000) BUT no nvarchar in PostgreSQL => TEXT memory limits to some variables the syntax slightly changed to more ... What would you improve in the DDL queries? See Question&Answers more detail:os...

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

0 votes

782 views

1 answer

database - How to update a single field of all documents in firestore using flutter?

I have a 100 user documents in database, and I have to update one field to 0 in all documents. How do we do it? See Question&Answers more detail:os...

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

0 votes

663 views

1 answer

database design - mongodb index data structures

Does mongodb discriminate between indices constructed of small, statically sized elements (lets say numeric types) and those with large variant types (such as ... it has some form of discriminated union ? See Question&Answers more detail:os...

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

0 votes

850 views

1 answer

database design - MySQL: Using DATETIME as primary key

My database will be storing a large number of data points, so I am using an unsigned BIGINT as the primary key. Would it ever make sense to use a DATETIME object as the primary key? Thanks, See Question&Answers more detail:os...

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

0 votes

524 views

1 answer

database - Data modeling question

My clients use one of the following when they sign up for my application: Foo API (requires a "auth_key", "password", "email") Acme API (requires a ... rationale as well (ie, better for performance, etc) See Question&Answers more detail:os...

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

0 votes

762 views

1 answer

database - Why does ora_rowscn change without updating a table

I work with ora_rowscn to track the changed rows on a table and to work with updated rows. Last week I noticed that for some (not all) of my tables that ... what is the solution to get it work or fix it? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags