Questions tagged as 'sql'

Tagged questions
1
answer

How can I rephrase a query that uses subqueries?

I want to reformulate a query of a stored procedure that uses a series of subqueries from from . PROCEDURE RPT_MOSTRAR_ESTUDIOS(p_ndat_id NUMBER, p_nusr_id NUMBER, c_cursor OUT refcursor) AS BEGIN OPEN c_cursor FOR SELE...
asked by 13.10.2016 / 02:07
1
answer

Connection to SQL Server

I'm trying to make a connection from my local project to a SQL database that I made and uploaded to a server, the server gives me the string connection to use, but when I use the open it throws me error SqlConnection cn = new SqlC...
asked by 01.09.2016 / 22:27
1
answer

Error "No matching unique or primary key for this column-list" with a compound station

Doing a job I found the error:    DAN_FACTURA (INVOICE), "No matching unique or primary key for this   column-list " Reviewing my table DAN_FACTURA I checked the statement and, as far as I know, I have correct my syntax for the Prim...
asked by 12.10.2016 / 22:41
0
answers

Optimize Query so as not to overload more temporary tables [closed]

I have the following query structure but when executing it I get the following error: "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP" 01652. 00000 - "unable to extend temp segment by %s in tablespace %s" *Cause: Failed...
asked by 08.11.2016 / 15:26
0
answers

Because my stored procedure does not return values to my php

I have a small problem, The execution of my stored procedure from my php does not return values: $op=1; the variable $op contains the number of my procedure the variable $cadena contains the search for the where $S...
asked by 11.08.2016 / 16:45
2
answers

Error Timeout ASP.NET SP

I have a detail when loading the StoredProcedure and fill in a datatable , I mark the error:    "Timeout expired The timeout period elapsed prior to completion of the operation or the server is not responding The statement has be...
asked by 16.08.2016 / 19:31
1
answer

sql queries with sql server 2016

I'm writing to see what's wrong with this query: Name of the teacher who teaches all subjects first select nombre from profesor inner join imparte on (profesor.p# = imparte.p#) group by nombre having (curso like "primero")     
asked by 13.06.2016 / 19:40
0
answers

I can not see the tables in the master database in SQL Server 2008 [closed]

I can not see the tables in the master database in my SQL Server 2008 R2 , enter the database with the user sa strong> from SQL Server Management Studio 2008 and when expanding the tables I do not see any. Thank you in advance fo...
asked by 16.06.2016 / 00:25
0
answers

migrate sqlserver database to postgresql [closed]

Will someone have a program to migrate from sqlserver to postgresql? I have recently used the ESF Database Migration Toolkit but unfortunately it is paid and the demo modifies the fields of the database with a "T" at the beginning of each record...
asked by 09.07.2016 / 18:33
1
answer

Send ASP form to SQLServer

Working with webforms when sending the data of my form to codebehind to be processed does not save them in the DB. <form action="formulario.asp.cs" method="post"> <label>Title</label> <input type="text" class="...
asked by 27.05.2016 / 16:31