Questions tagged as 'sql'

Tagged questions
0
answers

Connect my pc's database to the hosting

I want to connect the hosting to the local database of my PC I'm using linux. I have the doors 1604 and 8080 open. When I access my ip: port on an external network, I can access my website. But when I go to the hosting, it does not connect to th...
asked by 05.08.2018 / 09:30
0
answers

SQL - Aligning Column Values to Right

Hello I would like to know if by means of a SQL statement there is some possibility of aligning the column values to the right. Here's an example below that I can do via C #, but I wanted to do the alignment only via T-SQL: C # code that w...
asked by 07.08.2018 / 21:35
0
answers

Spring - @Query with JOIN returning UNKNOW instance

I have this Endpoint in my controller: @GetMapping("/validationsList/{search}") public ResponseEntity<Page<IntRaptMecListDTO>> getListOfAppointmentsBySearch( @RequestParam(value="page", defaultValue="0") Integer page,...
asked by 03.08.2018 / 21:03
5
answers

MySQL Limit Equivalent in SQL Server

Does anyone know how to relate the differences between MySQL and SQL Server, including using LIMIT n,n ? Or if they have a link that lists the differences would be cool. Example SELECT * FROM tabela LIMIT 50, 100 What would be the...
asked by 26.03.2014 / 17:01
0
answers

Error adding Stored Procedure to the map in Crystal Reports

When adding an SP with parameters of data type data, adding the following error information is displayed. Variables in SP ALTER PROCEDURE [dbo].[spExtractoTSL] ,@DataInicial DATETIME = 0 ,@DataFinal DATETIME = 0     
asked by 10.08.2018 / 12:23
0
answers

Problems with Stored Procedures in Laravel 5.6?

I am making a select in a procedure , but I can not page because the result returns array : DB::select('EXEC PR_MONITORAMENTO @FUNCAO="S2", @ID_CD_INTERNACAO='.$ID_INTERNACAO.', @ID_CD_CONVENIO='.$ID_CONVENIO.',@NM...
asked by 30.07.2018 / 16:27
3
answers

PHP + SQL Add two values from the same column

I have a table like this: Ineedtoaddthevalueofid1tothevalueofid15,savinginavariableinPHP.I'veresearchedalot,butIdidnotgetsomethingspecificforthat.Thanksforanyhelp!NOTE:Ihavetryingthefollowingbutitisreturning1,whentherightoneistoreturn49,14:$...
asked by 26.07.2018 / 22:55
2
answers

How could I improve this SQL query with sub querys?

There are many sub selects, how could I improve this query in MySQL and make a sum of max of 'total_points_period'? Take the total of points for a period of the "user_bigdata" table and the total points of the "olympic_players_niveis" table a...
asked by 24.07.2018 / 19:33
1
answer

fatal error oci_connect

Hello, I'm starting my studies in this area, sorry if you ask some nonsense question !! I have an oracle database that is in a virtual machine, and I'm doing a university job and I would like to connect this web system to this bank .. so my d...
asked by 24.07.2018 / 17:14
0
answers

MON $ REMOTE_PROCESS does not recognize .jar

I'm creating a Logging service for the Firebird database. I was using MON$REMOTE_PROCESS to get through where the change was made. But it does not recognize .jar . When I query: SELECT MON$REMOTE_OS_USER, mon$attachment_id, MO...
asked by 30.07.2018 / 20:59