Questions tagged as 'sql'

Tagged questions
1
answer

VB.NET - Public Shared Function

I have a function in a VB.NET system that I use to run queries in DB. The function is Public Shared for the sake of simplicity. And there is the question whether competing access to function could generate problems. This is user 'A' calls the...
asked by 26.05.2015 / 00:31
1
answer

Remote procedure call failed. [0x800706be]

After you install SQL Server 2008 R2, access the SQL Server Management Studio but the server name does not appear and the SQL Server Configuration Manager services are not active.     
asked by 26.05.2015 / 14:48
1
answer

ASP with SQL bringing different query result

Good afternoon! We are finalizing a panel that will bring the results of a SQL into an ASP page. We already have two finalized panels that are pulling the results perfectly. Only one of the panels does not return the result with the SELECT th...
asked by 16.07.2015 / 20:16
3
answers

SQL query in table wp_postmeta

How do I do a SQL query on a table that has the following fields: SELECT meta_key,meta_value from wp_postmeta where meta_key = 'cidade' and meta_key = 'bairro' the fields of the table wp_postmeta field meta_key = 'City' and meta_value = 'Cu...
asked by 13.05.2015 / 15:53
1
answer

Create column 'timer' in SQL

Is it possible to do a timer type column, which calculates 24 hours? For example, PHP starts this timer in this column, and until it zeroes the user is prevented from performing such an action. However, when it does, it returns to 24:00:00 and o...
asked by 15.05.2015 / 11:57
1
answer

Query Count SQL with percentage in PHP

I am making a report and need to count and display the number plus the percentage for the total count. With this code I already count. Is it possible to display the percentage next to it using sql and php? $sql = "SELECT customer.country,...
asked by 07.05.2015 / 03:55
2
answers

SubSelect in same column

I'm trying to create a subselect in the same column, I have to use a column row to get back a new value from the column itself. follow my sql code SELECT 'idUnidadeOrganica', 'NmUnidadeOrganica', 'idUOSuperior', (SELECT 'NmUnidadeOrganica...
asked by 08.05.2015 / 17:43
2
answers

How to mount a select that brings information of which column is PK, which is not, and what is FK

I need a TSQL that brings me some table information data like which column is IS_NULLABLE , COLUMN_NAME , and so on, but I came across a problem, I can not bring a column in a CASE WHEN which says that such a column is PK, w...
asked by 17.06.2015 / 03:12
1
answer

Connection between 3 tables to retrieve information, sql

I have 3 tables with this structure Itriedbutcouldonlygetintotwotables,butIwouldneedtobeinthe3to"save / clean" code. It is necessary to enter in the table helpcenter_topics to get a 20 topics plus recentemente inseridos...
asked by 04.06.2015 / 01:46
1
answer

How to delete records from multiple tables at the same time?

I want to give delete in a student so I want to delete the records of that same student of all the tables where it is and its image of the folder where it is was guarded for this I use the following code: p> <?php /* * Verifica s...
asked by 21.04.2015 / 12:51