Questions tagged as 'sql-server'

Tagged questions
2
answers

SQL Query to add fields from different tables

Someone who can help me with this query. I have three tables with different names. Tabla Ejemplo1 fecha campo1 2017-01-01 0.00 2017-01-01 7.00 2017-01-01 0.00 2017-01-01 1.00 2017-01-01 0.00 2017-01-02 1.00 2017-01-02...
asked by 08.08.2017 / 10:17
1
answer

Join 2 SQL tables

I have these tables in sql . Table 1 ---------------------------------------------------- | articulo | Ubicacion | Existencia | ---------------------------------------------------- | 200116 | cy1112 | 1...
asked by 25.07.2017 / 17:37
1
answer

Show SQL Server fields in Telegram

I have the following code in python with connection to SQLServer database made in ubuntu (it is a bot for telegram): import pymssql from telegram.ext import Updater, CommandHandler, MessageHandler, Filters import logging logging.basicConfig(...
asked by 26.07.2017 / 02:14
1
answer

Bring a row that is not in one of the 2 tables

I have this query in sql SELECT SI_Articulo = COALESCE(t.SI_Articulo, c.SI_Num_Articulo), SI_Ubicacion = COALESCE(t.SI_Ubicacion, c.SI_Ubicacion), SI_OV = COALESCE(c.SI_OV,''), SI_Ubicacion_Fisica = COALESCE(c.SI_Ubicacion_Fis...
asked by 26.07.2017 / 18:08
2
answers

Table sys.sql_logins in SQL Server 2000

table sys.sql_logins in SQL Server 2000 validation of the following query in SQL Server 2000; SELECT RIGHT(name, 10) name, CASE WHEN is_disabled = 1 THEN 'No' WHEN is_disabled = 0 THEN 'Si' END [¿Habilitad...
asked by 21.07.2017 / 18:40
1
answer

Restore .bak in SQL Server CE

Good day to all, my question is as follows how to restore a sql server .bak backup to a sqm server compact edition .mdf database / or otherwise run a .sql script in sql server ce, thank you in advance for your help     
asked by 05.09.2017 / 22:19
1
answer

Symfony 2 access database of ms sql server and mysql at the same time

I work with symfony 2.5, doctrine ... I need to access two databases at once: one in mysql on a local server and one in ms sql server 2008 on a remote server. How do I configure the connections and the parameters to access both interchangeably?...
asked by 23.08.2017 / 01:58
1
answer

Partial backup of database

I need to create a partial backup of a SQL Server database (only some tables); for example if the table has referential integrity I must restore the tables that make up that integrity (parent tables, and daughters tables), I hope someone can giv...
asked by 03.08.2017 / 01:01
1
answer

Valid column name SQL Server-Python

I am developing a small application that depends on SQL Server and development in Python , this takes data of Sp of SQL Server that it has by default of name: xp_readerrorlog 6, 1, N'login', N'failed' As you see,...
asked by 23.06.2017 / 19:03
2
answers

Can a dropdownlist be filtered according to the letters that you enter?

I have the following DropDowList <asp:DropDownList ID="DropAgent" runat="server" CssClass="form-control"></asp:DropDownList> That filled in the following way with c# IList<mg1DAO> resultList = new List<m...
asked by 29.06.2017 / 22:34