Input: The customer claims that the application (.NET) when querying for some data returns data different from when the customer looks into the data table directly. I understand there could be va...

I need to build a kibana like dashboard over a sql database. Is this possible? or is there an alternative as easy as kibana (in term of integration) for sql?

sql = """ INSERT INTO [SCHOOLINFO] VALUES( '""" + self.accountNo + """', '""" + self.altName + """', '""&...

I am doing some performance testing on a SQL sproc and just want to bang out a quick data generator for testing. I am after a simple way to generate a pseudo random (true random not needed in this...

I'm trying to remove parenthesis and text within it. Eg: Column1 has data and cleaned data should look like column2 Column1 Column2 HF(abcd) HF BP(234) BP ATRS (2354) ATRS AB(PS) SD(12) AB SD I...

I have a table (Table1) which has a composite primary key(Column1 + Column2). I am using it as a foreign key in another table (Table2). Now I want to a SELECT statement to select all records from ...

Is it possible to create a partial foreign key (similar to partial indexes) in general sql / postgresql? I have not found a way to force referential integrity in the following case: Table A is soft...

I've got this query in a @SQLInsert annotation in Spring against an Oracle 11g database and, although it's inserting properly it is not updating the values but raising no error. Any ideas? If not,...

I have the following example data structure of customer that can be part of multiple groups using a junction table and data: CREATE TABLE customer(id) AS VALUES (0),(1),(2),(3); CREATE TABLE groups...

How can I query all tables' all table columns in a database? Method I've tried: get all table names using select tablename from pg_tables where schemaname = 'public' Process cmd string using UNI...

I have a table which contains a primary key column which is auto incremented from application. How can I modify the column to be an identity column in Oracle 12c? A sample case is provided below- ...

Consider the following simple DAG: 1->2->3->4 And a table, #bar, describing this (I'm using SQL Server 2005): parent_id child_id 1 2 2 3 3 4 //... other edges, not connected to the su...

Just installed the iPython-SQL extenson, but when I run %load_ext sql I get an error "The sql module is not an IPython extension." I installed it via pip by pip install ipython-sql and when ...

I'm having a hard time working out how I should be installing the JDBC driver for PostgreSQL on my debian 6.0 server. I have moved the driver .jar into the following directory: /usr/local/pgsql/sh...

I'm trying to add a column to a table in my Postgres 9.3 database with this seemingly simple SQL: ALTER TABLE quizzes ADD COLUMN deleted BOOLEAN NOT NULL DEFAULT false; However, I'm getting the ...

I have SQL Server Reporting Services 2008 and when I open the following URL: "http://localhost/Reports/Pages/Report.aspx?someReport" I'm getting report screen in which I fill my parameters and...

Refer this! I was creating a database and got this error i tried to uninstall and then reinstall postgresql-16 and pgadmin4 but it didn't work for me! It creates a database but gives this error i a...

I was working on an Access database which loved auto-numbered identifiers. Every table used them except one, which used a key made up of the first name, last name and birthdate of a person. Anyways...

Here I have a table with a time column (datatype is integer), now I need to convert the integer value to time format HH:MM:SS:00 in SQL Server 2008. Also need clarification in the above time forma...

I'm trying to query a like statement across multiple columns. I have the following search terms: 'dog' 'cat' 'rabbit' 'gerbil' 'guinea pig' 'hamster' and I need search for these terms or terms LIK...

I use DBeaver for my main IDE to query multiple databases. When I query a table, it automatically generates a long select statement with all columns in one line. When I am making more complex que...

Can/Should I use a LIKE criteria as part of an INNER JOIN when building a stored procedure/query? I'm not sure I'm asking the right thing, so let me explain. I'm creating a procedure that is going...

I'm trying to convert my Date which is (eg. 2012-04-20 05:54:59) format in into mm-yyyy. I came across some solutions that says you would need to convert into varchar . Is there any way using the C...

I don't want to create a custom function for that if such function already exists in SQL Server. Input string: This is my string to convert Expected output: This Is My String To Convert

I have a database of several tables in which the first field is defined as: 'ID' INTEGER NOT NULL UNIQUE ... PRIMARY_KEY('ID') I do not use the AUTOINCREMENT keyword for any of these tables yet my...