Questions tagged as 'sql-server'

Tagged questions
1
answer

Problem when executing SQL Server statement

I have a problem executing a statement in SQL Server CREATE TABLE venta ( idVenta INTEGER PRIMARY KEY, Fecha DATE NOT NULL, Cliente_Cedula INTEGER NOT NULL, producto_idProducto INTEGER NOT NULL, empleado_Cedula INTEGER NO...
asked by 28.02.2018 / 02:05
0
answers

this local computer is not member of windows failover cluster

I'm seeing clusters, but I have these errors, I've searched and they say that I install normal first, but I do not see or find the part to configure that In this image it says:    this local computer is not member of windows failover cl...
asked by 26.02.2018 / 05:57
1
answer

How to get the cumulative total value of a month in SQL

I have the following question with SQL: I want to take out the maximum month of purchase of a certain article. With this consultation, the purchase of the item accumulated in THE LAST 12 MONTHS: SELECT ARTICULO.ARTICULO, ARTICULO.DESCRIPCIO...
asked by 21.02.2018 / 16:56
1
answer

How to load a mysql table with php?

Good morning, I'm new to php, I need to load a complete table that is in my mysql database and show it as a table with its header and everything on my website, if you could help me, thanks?     
asked by 19.02.2018 / 16:34
0
answers

I have an Error 53 sql server and can not find an instance

I have a problem with SQL Server 2017, because when I connect and authenticate with Windows I get a error 53 . Which says that the specific path of the instance to connect was not found. I opened the SQL Server Configuration Manager but I di...
asked by 11.02.2018 / 20:41
0
answers

conxion DB on android with MSSQL auth

I'm trying to connect to a BD from an Android device, but the DB is in MSSQL with windows authentication through a VPN. Download to the device the Sonicwall app which connects me to the VPN but when running the project I have this error: java...
asked by 07.02.2018 / 04:35
1
answer

Query type JOIN with 2 SQL server databases?

I'm doing a comparison between 2 tables of the same name with PHP from a database in SQL SERVER <?php $sql = "SELECT ITM1.ItemCode, OITM.ItemCode, OITM.ItemName, ITM1.Price, ITM1.PriceList FROM OITM, ITM1 WHERE ITM1.ItemCode = OITM.I...
asked by 06.02.2018 / 19:56
1
answer

problem installing Microsoft SQL Server 2014 CLR Types 32bits

before installing reportviewer asks me to install Microsoft SQL Server 2014 CLR Types of 32bits, I have the 64bit that works perfectly on a 64bit machine     
asked by 06.02.2018 / 23:22
3
answers

Passing data from a selected row of a datagridview to an SQL table

Good community I hope you are very well. My question is the following: I have a datagridview in which I load certain information according to a search that I do, from that datagridview I can select 1, 2, 3 or all the rows if I want it. Now I wan...
asked by 19.02.2018 / 22:55
1
answer

Generate a script in SQL Server

I need help to generate a script that allows me to execute an action in this case a GRANT , the example I have is the following: select 'GRANT insert, select, delete, update on '+ name + ' TO bodeguero' from BODEGA.sys.tables...
asked by 02.02.2018 / 03:29