Questions tagged as 'sql-server'

Tagged questions
1
answer

Enter data with SQL SERVR in node.js [closed]

I would like someone to give me an example of how I can enter data in a SQL SERVER database from Node.js please! Thanks:)     
asked by 04.09.2018 / 18:34
1
answer

'MSDASQL' does not support the required transaction interface

I have created a linked server between a Microsoft SQL Server 2000 and MariaDB Server 10.1.17. For this I used the ODBC connector version 5.1 downloaded from the MySQL website. The problem that arises is when doing distributed transactions...
asked by 21.09.2017 / 13:47
1
answer

how it works not for replication in the triggers

Hi, I'm trying to understand how the triggers work when you specify not for replication, if for example I have a trigger instead of update not for replication that works on a view and instead of updating that view what it does is up...
asked by 31.10.2017 / 17:21
2
answers

Migrate table from SQL server to MySQL

I have 2 systems (One in asp and one in PHP ) The one in asp is connected to SQL server and PHP to MySQL. In SQL Server I have a table called "Clients". This table is updated every 2 or 3 days. In MySQL , I have replicated...
asked by 31.10.2016 / 13:59
1
answer

Select images from the sqlserver php database

I have a query that selects information from the database but I can not print the images on the screen, the address of the images folder are in \192.168.10.129\sapshared\FOTOS\KennedyDB but the application is running from 192.168.10.134...
asked by 08.05.2018 / 16:33
2
answers

SELECT within a CURSOR

I have the following cursor: The idea is to consult a list of "Demands", the interesting thing is that some are created by users and others automatically by the system, within the list you want to know which are created by user and whic...
asked by 21.03.2017 / 07:16
2
answers

subtracts with selected values from different tables

I have a problem which I hope can help me, I want to add values of a tabla1 and can subtract them from other values selected from another tabla2 under condition of tabla 2 like=´A%´ adding these values and subtracting them f...
asked by 04.12.2018 / 16:13
1
answer

Numbers ending in 99 SQL

Hello good morning community! I wanted to ask you how I can get from a table (for example a price column) all the numbers that end in "99" any ideas? Thanks     
asked by 08.11.2018 / 13:40
1
answer

How to divide or separate a query? [closed]

I create a Virtual table (Fictional) SELECT TOP 1 ItemID INTO #Temp FROM PS_GameData.dbo.CharItems WHERE ItemID = 1001 INSERT INTO #temp VALUES((SELECT ItemID FROM #Temp)); SELECT ItemID FROM #Temp DROP Table #Temp How do I separate this qu...
asked by 09.02.2017 / 13:56
2
answers

How to enter data to multi-linked tables

Maybe the title is not well formulated, but my question is this, the teacher put these tables together but when entering values I must put data that I obviously do not have yet because everything enters a vicious circle where I can not (or...
asked by 09.03.2017 / 07:05