Questions tagged as 'sql'

Tagged questions
0
answers

How should you group this query?

Good morning companions, I have the following table co_orderdetail The detail is that I want to list it in columns in the field ordercoin I have executed it like this and it shows me this result: SELECT id_order,...
asked by 04.04.2018 / 23:27
1
answer

I have problems with android study when entering variables and other

hello friends, how could you tell me why you mark error in these lines of code my android studio, the lines of code that appear in bold or with double asterisk are my mistakes, someone to help me please is urgent package com.example.danhermes....
asked by 31.03.2018 / 18:15
0
answers

Print the two variables of two tables

My problem is this: I want to print the result of two fields that are in two different tables and that show like this: field1-table1 field1-table2 field1-table1 campo1-tabla2 What I have is this and it prints me the values of one table...
asked by 25.04.2018 / 22:02
0
answers

update and concatenate columns POSTGRESSQL

I would like you to help me with this doubt. I want to make an update in a new attribute that I add to my table, the situation is the following when doing that update I want to concatenate three columns. when I execute this code: update saber2...
asked by 01.04.2018 / 05:58
0
answers

Retrieve a database

Delete a database from the object browser, do you know if there is a way to recover it with a program or something like that?     
asked by 02.05.2018 / 18:23
2
answers

How to add 7 column in Sql?

I have the following query in which I get the following result: I want to add a column for each row, Thank you very much. SELECT COUNT (ID_MODALIDAD_TIPO_TRAMITE) as "" FROM SOL_SOLICITUD_TPO_TRAMT_MODL WHERE ID_MODALIDAD_TIPO_TR...
asked by 03.04.2018 / 17:59
1
answer

Can I update several elements of my table at the same time?

I have a customer table from a bank box. There are different fields, such as Identifier, User_Code, User_Name, User_Current ... I have to modify a field of four different clients but they belong to the same table: update miTabla set Fec_Anulac...
asked by 26.03.2018 / 16:01
1
answer

unsupported keyword 'provider'

Hello good day I am developing an ABC system everything I do with SQl Connection and it worked perfect but I found a code to validate if there was a record in the database with the same name this example used an OleDb (it works) but at the time...
asked by 26.03.2018 / 18:30
1
answer

Upgrade sql server 2008 to 2016

Where are you thinking about doing the upgrade of sql server 2008 (SP4) Enterprise Edition 64 bit A Sql server 2016 ???. We have a DWH and I would like to know what I need to know for migration, compactibility of versions between the two. I a...
asked by 26.03.2018 / 15:36
0
answers

sql server 2012 BackUp error

Good day, I want to backup my database but when I do it I get the following error :    The backup of the file or group of files "sysft_CatalogoMedicos" is not allowed because it is not online. Container status: "Offline" (7).       Restorat...
asked by 26.03.2018 / 20:01