Structured Query Language (SQL) is a language for querying databases. Questions should include code examples and table structure. This tag refers to the standard language, not for questions about specific vendor extensions, like MySQL or Microsoft SQL Server, so if you think your question relates to ...

learn more… | top users | synonyms (5) | sql jobs

0
votes
1answer
6 views

transform oracle's xml to html using xslt?

I need to transform xml (to html using xslt) file which I made by downloading a dataset from oracle sqldeveloper HR schema! Please help me to write xsl file which will transform the downloaded data ...
1
vote
2answers
8 views

Why doesn't oracle ignore referential integrity constraint for direct-path insert

According to, http://docs.oracle.com/cd/B10500_01/server.920/a96524/c21dlins.htm#10778 During direct-path INSERT operations, Oracle appends the inserted data after existing data in the table. Data ...
0
votes
4answers
27 views

Get warmest and coldest temperature from the database

I want to get the warmest and coldest temperature from the database but ORDER BY data_temperature with ASC or DESC and SELECT MAX(data_temperature) FROM ... doesn't work. I'm only getting 10.0 with ...
0
votes
2answers
25 views

Give value to radio button php and save to sql

I have a little problem that i have been struggling for the last 16hrs I can find a solution for this... I really really need some help please... I have the form which is generated by a query based ...
-2
votes
5answers
21 views

How can i frame a query for this

I have a table like this: staffname | periods ___________________ david | yes seema | no raj | yes seema | no david | yes Now i want the result like this: ...
0
votes
1answer
17 views

SqlDataSource makes DropdownList results to one item that is duplicated in the list for displaying in GridView

I have a Visual Studio 2010 asp.net page in VB where I have joined multiple tables with the SqlDataSource to display specific columns in a gridview. After the table join, I have a dropdownlist where I ...
0
votes
1answer
31 views

SQL WHERE with conditions but no CASE-statement

I have to work with a given database. I found this article, but did not succeed in adapting it for my needs: http://weblogs.sqlteam.com/jeffs/archive/2003/11/14/513.aspx What I want to do I work ...
1
vote
1answer
15 views

Get Total Rows From Join Based On Value From Join Table

Im not sure about the title, anyone can edit as pleased Table articles +----------+-------------------------+----------+ | id | title | status | ...
0
votes
1answer
20 views

SQL query table filtering

I have a question regarding a query in MS Access. My database has cooking recipes, and what I have need is a query that will return all the meals that can be made with the available ingredients. The ...
-2
votes
0answers
19 views

How to access local server database from web server?

I have a Microsoft SQL Server installed, I want to use it from my web server to access the database. I googled, but didn't find cost effective solutions (Mostly SSH tunneling, or DynDNS). Can you guys ...
0
votes
5answers
36 views

Join only if field is more than zero

Instead of making 2 queries could I somehow just join persons if houses.owner_id is greater than zero? SELECT * FROM houses INNER JOIN persons ON persons.id = houses.owner_id WHERE houses.id = id
0
votes
2answers
36 views

number format in SQL INSERT

Hi guys i need some support on number format in SQL INSERT INTO i need to convert {$data['rank']['points']} as number format, so that instead of it showing as 5467389 it converts it to 54,673,89 the ...
0
votes
2answers
48 views

Using a SELECT Query to look up a UPDATE Query on MySQL

I'm using a SELECT query to obtain a variable using mysql_fetch_assoc. This then puts the variable into an UPDATE variable to put the returned value back into the database. If I hard code the value, ...
0
votes
1answer
16 views

VB.NET and SQL INSERT INTO; data is truncated

I use VB.NET Studio Express 2012 to read a filestream into SQL Server Express. The database and table are created fine, most records load without error using .ExecuteNonQuery INSERT INTO, but some ...
0
votes
0answers
22 views

Recursive function to select a hierarchy for a table without using connect by. PL SQL

I need to select all the tables that have references to my table in a recursive manner. So, lets say I need to perform this task for the book_author table. A query like this one: select distinct ...

1 2 3 4 5 9208
15 30 50 per page