Questions tagged as 'sql'

Tagged questions
0
answers

error when installing sql server 2008 express on a virtual machine

Hello good morning a question create a virtual machine with windows 7 to use sql 2008 express but when installing I frame the following error:    "The MOF compiler could not connect to the WMI server.   may be due to a semantic error as an in...
asked by 29.03.2017 / 16:45
0
answers

Return text in plpgsql?

I am doing an exercise for class in which they ask me the following:    Create a function that returns a text with a list of the notes of a   student indicated by parameter. The input parameter is mandatory.   You have to return null if the p...
asked by 29.03.2017 / 14:49
1
answer

Java jdbc general error

Hi, I'm creating a method to add an employee to the database, specifically to the table used, where one of its fields is the branch to which it belongs. In the event that the branch does not exist, I must insert it in the branch table. The pr...
asked by 25.03.2017 / 13:16
1
answer

Query to associate the field of a table with its default value

I am doing a large query to generate a data dictionary, where I am indicating to each field of the table if it is fk, pk, if I have designated a default value (CONSTRAINT-- DEFAULT ()). And it is in the latter that I can not associate the field...
asked by 21.03.2017 / 15:53
1
answer

Query database from internal memory

I am working on an app and I need to use a BD SQlite (already created) from the internal memory of the mobile. I have searched and can not find, I already know how to create the BD from scratch in the app itself or copy a BD to the assets folder...
asked by 21.03.2017 / 07:32
1
answer

LEFT JOIN MYSQL

I have 3 tables from which I am trying to collect data by doing LEFT JOINS. In the contacts table I have 2 types of contacts, people and companies each with their unique id and another associative one. When I execute the query that I leave...
asked by 21.03.2017 / 09:16
0
answers

PostgreSQL connection with C #

then I leave the code I am using to connect and insert records in my database NpgsqlConnection conn = new NpgsqlConnection("Server=localhost;Port=5432;Database=demoluis;User Id=Luis;Password=micontraseña;"); conn.Open(); Npgsql...
asked by 13.03.2017 / 07:59
0
answers

Foreign Key Constraint

I have a problem with a database (.sdf) in Visual Studio 2012 I have the following tables: The primary key of branches I have related to the field Branch in the table Cars The problem is that I enter a record in the table Branches with...
asked by 09.03.2017 / 01:40
1
answer

Efficient way to move tuples from one table to another, discarding repetitions of a specific attribute

I have two tables, and I have to move data from one to the other. The first table stores, among other things, customer data. The second table is empty, it is where I want to insert the tuples. The first table has this form, I do not write it...
asked by 06.03.2017 / 16:43
1
answer

SSIS: OleDB to Excel problem in a varchar column (1000)

When exporting from a SQL database to Excel in SSIS, I have a problem in a column in SQL that is VARCHAR(1000) , I tried to pass it to Unicode_Ntext , but I get the error:    [Excel Destination [84]] Error: An error occurred while...
asked by 22.02.2017 / 21:31