Recent questions tagged Database

0 votes

986 views

1 answer

database - Monitoring the progress of an SQL query in SQL SERVER

I saw a similar question which asked how to monitor the progress of a backup/restore operation: Is there a ... DURING the query's execution. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Error ORA-00932 when using a select with union and CLOB fields

First of all, this isn't a duplicate of this question. If it is, sorry but I couldn't solve my problem ... this problem. Thank you very much. See Question&Answers more detail:os...

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

0 votes

946 views

1 answer

database - Ruby on Rails: Model Association with multiple foreign keys

I am working on a User model, and each user should be able to have both students and teachers. However, ... how to deal with creating links. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - How to query graph/hierarchical data in mysql

Suppose I have a table of objects structured in a hierarchy: A |--B |--C | +--D +--E They are ... with a simple GROUP BY and MIN statement. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - Android Utility to send sqlite db to server

In my application I want to send data stored in the local sqlite database to server's sqlserver database. Is ... key violation. Please help. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

database - SQL - Should I use a junction table or not?

I am creating a new SQL Server 2008 database. I have two two tables that are related. The first table ... pk ModelDescription // varchar Thanks! See Question&Answers more detail:os...

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

0 votes

962 views

1 answer

database - Android Eclipse DDMS - Can't pull file from rooted device

I am testing my app on a rooted Nexus S phone. I finally have access to the /data/data folder thanks to some ... look at it in a SQLite editor? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database connection - Tomcat6 can't connect to MySql (The driver has not received any packets from the server)

i'm running an Apache Tomcat 6.0.20 / MySQL 5.1.37-lubuntu / sun-java6-jdk /sun-java6- ... : Deploying configuration descriptor myapp.xml See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

database - What ORM can I use for Access 2007 - 2010? I'm after WPF binding to the tables etc

I've a legacy database that all sites have, it describes specific content in a number of catagory/subcatagory/child ... can marry to Dapper :). See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - What is the best way to get distinct contacts in Android

I am successfully storing contacts in parse.com dashboard data browser by this code. public void readContacts(){ ... Thanks in advance... See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Hierarchical Data - Nested Set Model: MySql

I am just learning how to implement the Nested Set Model but still have confusion with a certain aspect of it ... . Red, Yellow, Green)? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Bind variables in R DBI

In R's DBI package, I'm not finding a facility for using bound variables. I did find a document (the ... having to reimplement it [badly]. See Question&Answers more detail:os...

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

0 votes

971 views

1 answer

database design - Is prefixing each field name in a table with abbreviated table name a good practice?

Do you prefix each field in a table with abbreviated table name? Example: Table: User Fields: user_id user_name ... voted one as accepted. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - Is it faster to search for a large string in a DB by its hashcode?

If I need to retrieve a large string from a DB, Is it faster to search for it using the string itself or ... : I am using C# and MSSQL2005 See Question&Answers more detail:os...

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

0 votes

921 views

1 answer

database - Is it good practice to have foreign keys in a datawarehouse (relationships)?

I think the question is clear enough. Some of the columns in my datawarehouse table could have a relationship ... is somewhat clear enough. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

database - oracle systimestamp (sysdate) to milliseconds

Could you provide implementation of stored function to get current systimestamp as milliseconds. Something I can use like ... 1970 UTC. Thanks. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

database design - is `date` a valid mysql column name?

I was wondering if date is actually a valid mysql column name? According to the manual MySQL permits some keywords ... date as a column name? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

database - Is there a way to create multiple triggers in one script?

I am trying to create multiple triggers with only uploading one script into an Oracle DB / APEX workspace, and ... your time and interest =) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - Connect PHP to IBM i (AS/400)

I've got an upcoming project wherein I will need to connect our website (PHP5/Apache 1.3/OpenBSD 4.1) to ... anyone else have any better ideas? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - MODIFY COLUMN in oracle - How to check if a column is nullable before setting to nullable?

I'm trying to fill in for a colleague in doing some Oracle work, and ran into a snag. In attempting to ... TABLE MyTable MODIFY(MyColumn NULL); See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

database - How to execute multiple queries using psql command from bash shell?

I need to execute postgresql queries from command line using psql -c command. For every psql command, it opens a ... the proper way to do it? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - How do I print a triangle of stars using SQL

Is it practically possible to create a triangle of stars like this as below in SQL.I know that this could be ... if anyone knows about it. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Open Source Address Scrubber?

I have set of names and addresses that have been entered into and excel spreadsheet, but the problem is that the ... do the scrubbing for me? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

database - Can I remove sa login from SQL server?

I am a beginner in database field and this question might sound too stupid but I want to know why there is ... am using SQL Server Express 2008. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

database - Is there a postgres command to list/drop all materialized views?

I am creating multiple views in my code and each time the code is run, I would like to drop all the ... Postgres or drop all of them? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

database - postgreSQL concurrently change column type from int to bigint

I have a pretty big table (around 1 billion rows), and I need to update the id type from SERIAL to ... whatever the time it will take)? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Rails: Is the version number in 'schema.rb' used for anything?

Now that Rails has timestamped migrations, the single version number at the top of /db/schema.rb seems pointless. ... schema definition ... end See Question&Answers more detail:os...

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

0 votes

968 views

1 answer

database - Is it possible to map a table name for a domain object dynamically in grails?

I have a domain that looks something like class Foo { String name static mapping = { table 'foo' } } but ... this is even possible? Thanks! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags