Questions tagged as 'sql'

1
answer

Insert data from Visual Studio to SQL Server

How can I solve this problem when inserting data from Visual Studio.net into SQL? This is my code that I use: Imports System.Data.SqlClient Public Class Form1 Private Sub BtnInsertar_Click(sender As Object, e As EventArgs) Handles BtnInserta...
asked by 23.07.2017 / 22:43
2
answers

Save an UPDATE in a variable

I have a question, I would like to save a UPDATE within a variable, for example, this is my code: public static function cancelTareasP(Usuario $_Usuario, $proyecto_id) { $conex = $_Usuario->getConexBD();...
asked by 02.08.2017 / 17:59
1
answer

how to pass a data from a table in sql to a label even if the table is empty in visual basic

I have this code to pass the data: Using Conn As New SqlConnection("Data Source=SAMUELSUSANA; Initial catalog=poovb;integrated security=true") Conn.Open() Dim ConsultaSQL = "SELECT TOP 1 Codigo_venta FROM tblventas ORDER BY...
asked by 02.08.2017 / 22:42
1
answer

Unable to connect to server SQL SERVER 2000 SQL Authentication

I need to perform a Hardening validation for a SQL Server 2000 database migration to SQL server 2008, trying to connect through some client (Microsoft SQL Server Management Studio) to SQL Server 2000 or from LocalHost with (SQL Query Analyzer )...
asked by 21.07.2017 / 14:48
0
answers

Problem with while fetch_assocc and string

What I try is to get data from the database to create HTML tags of type option but the problem is that what I need to send is a string and not a array . The JavaScript that sends the information between HTML and PHP works...
asked by 24.07.2017 / 22:10
1
answer

SQL query to filter a table using two tables

I currently have 4 SQL tables in this way: CustomersTable, RegistrationTable, OrdersTable and OffersTable I have to write a SELECT statement that lists all the clients in the CustomersTable table (all fields), which contain rows in t...
asked by 22.07.2017 / 15:03
2
answers

SQL Where do I put the foreign key table hiija or father?

CREATE TABLE personajes( per_nombre varchar(50) not null default 'Desconocido' , per_genero varchar(30) not null default 'Desconocido', per_raza varchar(50) not null default 'Desconocido', per_alias varchar(50) not null def...
asked by 15.07.2017 / 18:36
1
answer

Query data from an XML field in SQL 2014

I have an XMLData table. In your Data column I have data like the following: <?xml version="1.0" encoding="utf-16"?> <table> <id>{6ebd0af9-9838-47f5-8aad-45cf9d4201f7}</id> <rows> <row> <col...
asked by 27.07.2017 / 09:20
2
answers

Inconsistency in query result "isnull (column, '') returns a space"

During the process of producing a solution in C # records were saved forming a "folio" with a literal, a cell value and an id 'C'+ISNULL(Columna1,'')+Columna2 Example of result: C96 CX85 The queries have not changed, the same database...
asked by 27.07.2017 / 15:43
1
answer

Driver qsql for ARM architecture

I have a problem which is that when compiling an application with toolchains to a Card with Yocto Linux I can not connect to the database since the qsqlite driver is not found on the card and there are no other drivers available, this is the err...
asked by 13.07.2017 / 23:26