Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged database

0 votes
386 views
1 answer
    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
326 views
1 answer
    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
363 views
1 answer
    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
422 views
1 answer
    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
448 views
1 answer
    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
370 views
1 answer
    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
403 views
1 answer
    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
318 views
1 answer
    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
240 views
1 answer
    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
348 views
1 answer
    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
357 views
1 answer
    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
351 views
1 answer
    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
1.6k views
1 answer
    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
382 views
1 answer
    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
357 views
1 answer
    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
459 views
1 answer
    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
446 views
1 answer
    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
369 views
1 answer
    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
673 views
1 answer
    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
330 views
1 answer
    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
498 views
1 answer
    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
338 views
1 answer
    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
323 views
1 answer
    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
521 views
1 answer
    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
388 views
1 answer
    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
570 views
1 answer
    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
310 views
1 answer
    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
460 views
1 answer
    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)
Ask a question:
Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share

548k questions

547k answers

4 comments

40.3k users

...