Questions tagged as 'sql-server'

Tagged questions
0
answers

how to make dynamic table php sql server

Good afternoon: I AM REALIZING A DYNAMIC TABLE BETWEEN PHP AND SQL SERVER .But no error comes out but I have a record in the DB but they are not reflected in the table it comes out empty THIS IS MY CURRENT CODE: <?php...
asked by 05.01.2018 / 20:57
1
answer

Event in SQL Server Profiler showing error in restrictions

I have an application on vb.net that returns this error after running a TableAdapterManager: I would like to know if there are any events in the SQL Server Profiler that I run from SQL Server Management Studio 2016 that could give me more...
asked by 03.01.2018 / 08:45
1
answer

how do I pass this query [from mysql to sqlserver?

SELECT id_rubro, rubro, name_e AS Empresas FROM dbs_empresas, p_rubros WHERE rubro_id = id_rubro AND activa_e='Y' GROUP BY rubro ORDER BY rubro I get this error    Mens. 8120, Level 16, State 1, Line 1   Column 'e_rubros.id_rubro' is invali...
asked by 29.12.2017 / 00:21
0
answers

PHP AND SQLServer

I need help to register data from PHP to a database SQLServer . These are the connection data: $ server: "10.10.2.120"; $ user: "admin"; $ pass: "123456"; <!doctype html> <html> <head> <meta char...
asked by 23.12.2017 / 04:34
0
answers

Enigma with query in SQL server 2008

Good day, I'm trying to execute a query that throws me the auxiliary codes other than two tables that have the same description and can group them so that I show the same description (name) auxiliary with the different auxiliary codes. It shou...
asked by 21.12.2017 / 15:15
0
answers

Nested parameters in VB.Net and SQL Server

Greetings to all, I am making an application in VB.NET and SQL Server. I have a stored procedure that retrieves all the columns of a table, passing as a parameter the password, the detail is that I need to save the recovered data to send it as a...
asked by 02.01.2018 / 23:01
0
answers

Query from MySQL to SQLServer

Good day, I need to make a query from mySQL to Sql Server. This is the scenario: I have an application on a Linux server that works with a database in MySQL, there is a database that runs on Windows Server 2008 with sql Server, I need to bring t...
asked by 09.12.2017 / 19:14
0
answers

problem when updating money data from visual studio

the problem is that when wanting to update the table "product" all the data is updated well except the price, for example if I modify the name and status of the product but the value of the price of the product does not change it when wanting to...
asked by 06.12.2017 / 17:39
0
answers

Problem when executing service

Good morning, when I run a service I get the following error:    Windows could not start the X service on Local Computer.   Error 1053: The service did not respond to the start or control request in time. I want to know what causes...
asked by 04.12.2017 / 18:54
1
answer

How to do the following in SQL Server

Good, I have a question. What I have to show is the following in the case that cte was 1 you have to list the following pair (WITHOUT DATA, HOLDER, INTERIM, ALTERNATE, PROV.C / RETER, PROVISORIO AT TERM) and in the case of being cte 2 Show PERMA...
asked by 04.12.2017 / 14:00