Skip to main content
22 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
82 views

Postgresql conditionally include distinct in query Is there way to modify a query such as: select distinct col1, col2 from our_schema.our_table where (id = '1001') The goal ...
JosephDoggie's user avatar
  • 1,604
2 votes
1 answer
210 views

Synopsis: How to write the SQL code to insert one record from a flat-file into separate records to be inserted into a SQL Server table. Specifics: I have a table to record lease payments. For each ...
Greg's user avatar
  • 87
-4 votes
2 answers
484 views

Help me with this Dynamic statement perform faster, the statement will fetch top n values for each column from a table. The table will have an "n" number of columns but will have a primary key. NULLs ...
Dani Mathew's user avatar
  • 828
0 votes
1 answer
1k views

I have created function calling external script with arguments: CREATE OR REPLACE FUNCTION foo3(text, text) RETURNS TEXT AS $$ $ip = shift; $username = shift; $cmd="/bin/echo -n $ip $username > /...
user2913139's user avatar
  • 617
2 votes
1 answer
471 views

When writing an application which updates or queries a database, we use something called a database driver (e.g. a JDBC driver). I wonder why it is called a driver instead of a library? Is libpq a ...
user avatar
2 votes
1 answer
786 views

I'm currently looking at metadata solutions for Microsoft SQL Server 2016. I'm interested in using Schemaspy. I think it looks like a great free way to document metadata, but I'm worried that it may ...
Tom's user avatar
  • 105
0 votes
0 answers
299 views

Anyone has experience of using/developing a Data Access model which uses Entity Framework only for Insert/Update/Delete and raw SQL for Reading/Querying purposes. If any, how was your experience, what ...
Joe Gage's user avatar
  • 33
0 votes
1 answer
616 views

I am creating my own index method in PostgreSQL based on GiST as extension. I want one of my functions (check out Examples section) in my operator to behave differently based on a value defined by the ...
Zeruno's user avatar
  • 1,689
1 vote
1 answer
95 views

First time doing database programming, so I just made a database in Access to try to do something with it. The database I created called "TestDatabase" on my desktop, and the table I created inside ...
Leon Ma's user avatar
  • 303
0 votes
1 answer
681 views

I am attempting to specify a filter condition on an ADO Recordset where one of the field names contains both left and right square brackets as part of the name. The resulting condition string is being ...
HexTheKiwi's user avatar
  • 1
1 vote
2 answers
182 views

The Problem I have some code which I've coded in such a way to enable high maintainability and code re-usability. I am concerned about a particular piece of code and I would like a professional ...
Aelphaeis's user avatar
  • 2,623
-1 votes
3 answers
75 views

I have some code where I want to throw two exceptions; however, the exception are basically the same but with different values. I would like to know an elegant generic way to determine which of these ...
Aelphaeis's user avatar
  • 2,623
0 votes
2 answers
1k views

I have an application that stores information in a database based on the information from 5 text fields. I'm having trouble being able to sort through fields or just even sorting from one field. Also, ...
David Etim's user avatar
  • 1
2 votes
3 answers
159 views

I have a parameter table with 10 rows. Called parameter_table. In my PL/SQL procedure, I do loop in 2 million records. And each time querying this parameter table too. I want to load this parameter ...
Mehmet's user avatar
  • 2,288
1 vote
3 answers
1k views

I have a table named: schoolInfo in access 2007 and it has two fields (schName and mjrName). Now I'm trying to design a combo in Visual Basic 6 (cboMajors) which is related to the other combo (...
user2035282's user avatar
  • 11
3 votes
3 answers
596 views

I was wondering if it is possible to add/update/delete an SQL Server database table, as well as an Informix database table at the same time. Both databases will have the same table (data and all), so ...
leety's user avatar
  • 177
1 vote
2 answers
1k views

i was wondering if there is a way to enable cloud features for a SQLite database application. Should i save the whole database to the cloud each time ? For example when i quit the application is it ...
alexandertr's user avatar
  • 963
0 votes
4 answers
317 views

I want to ask you what programming language I should use to develop a horizontally scalable database. I don't care too much about performance. Currently, I only know PHP and Python, but I wonder if ...
user avatar
3 votes
1 answer
1k views

I'm recently trying to drop Doctrine due to performance and problems with abstraction and move to database driven logic. I'm using mostly PostgreSQL. Doctrine One thing that I liked about ...
Edke's user avatar
  • 161
6 votes
3 answers
7k views

What is the difference between a DataSet and a DataTable in .NET?
paramasivam's user avatar
  • 113
1 vote
3 answers
231 views

If I have the following table structure... Table 1: BlogPost PostId | Name | Text Table 2: Tags TagId | Tag Table 3: BlogPostTag PostId | TagId And the following stored procedure... ...
matt_dev's user avatar
  • 5,246
1 vote
1 answer
144 views

I have an existing database in mysql. One of my tables has discontinuous ids. I would like to modify the ids of the table so that they go from 1 to num-of-rows. This particular tables does not happen ...
flybywire's user avatar
  • 277k