Questions tagged as 'sql-server'

Tagged questions
1
answer

SQL - Assign a value in a data recovery operation

In a simple query, I have a table with the following structure: SELECT * FROM [SAMX].[dbo].[REPORTE_ESTADO_CUENTA_GLOBAL] where intencion_id=1657 ORDER BY intencion_id,fecha I need to fill in the column with a '0' or a '1' depending o...
asked by 28.11.2016 / 19:22
4
answers

How do I find the Server Name for SQL Server Management Studio 2017 RC1

I need to establish a connection to the SQL Server, but I can not get my Server Name . Does anyone know how to get instance for SQL Server V17.0 RC1 ?     
asked by 25.11.2016 / 04:27
2
answers

Query to select first record in both PostgreSQL and SQL Server

I need to select the first record of a query. But the problem is that top 1 only works in SQL Server , but not in PostgreSQL . And in PostgreSQL it works with limit but in SQL Server no. These are the examples. I would greatl...
asked by 19.09.2016 / 16:16
1
answer

returns more than one SQL result under query for trigger?

I have this trigger script created by me which executes a perfect UPDATE when it is a single user but when it is more than one or several User Fails the query by the trigger (BEFORE NOTHING SEARCH ON INTERNET that has to do with TOP 1 or IN the...
asked by 16.09.2016 / 20:14
1
answer

Restore DataBase.bak without affecting triggers Current SQL SERVER

How is a DataBase.bak in SQL Server 2008 R2 overwritten? While I have the Triggers in the database that is working. I need to do a restoration of it without affecting the triggers of the old database, that is to say that only the r...
asked by 20.09.2016 / 23:38
2
answers

Problem when inserting data in windows form c # form with sql

I am developing a program that I am doing for my class, it is a small program of a hardware store where product information is kept, clients (so that if it is a distributor, apply discount) , types of products and so on. The problem is in th...
asked by 26.08.2016 / 05:20
1
answer

Is it possible to execute a stored procedure with one click?

I have a store procedure in SQL and I would like to know what is the simplest way to execute it. This is a set of tables that must be updated once a year, but you will not opt for the JOB because the update date will never be the same. The id...
asked by 15.08.2016 / 16:59
1
answer

Invalid JSON response

I'm using Datatables and showing the data from an HTML table works perfectly, but when I want to show SQL Server data from PHP I get the following error: My PHP code works in the following way: <?php session_start(); if (isse...
asked by 28.07.2016 / 18:57
2
answers

Error compiling PocketPC project

I have the following error:    Error 1 Registration or implementation error: 0x8973190d. Failed to open file '% CSIDL_PROGRAM_FILES% \ Microsoft SQL Server Compact Edition \ v3.5 \ Devices \ wce500 \ ARMV4i \ sqlce.ppc.wce5.armv4i.CAB'. Error...
asked by 27.07.2016 / 20:09
1
answer

Insert DataTable in SQL Table

Good morning, how could I insert the following code into the database? I hope you can help me. Sub BtnCrearClick(sender As Object, e As EventArgs) Dim IDColumna As New DataColumn(txtID.Text) IDColumna.DataType=GetType(Integer)...
asked by 08.06.2016 / 02:52