Questions tagged as 'sql-server'

Tagged questions
2
answers

Error in DBExpress with Delphi + SQLSERVER

Dear, I have this error: SQL STATE 42000, SQL Error CODE 201 Look for information on the internet and I can not find the solution. Client side script: var client : TTServerMethodsClient; var ds:TDataset; var dst:TDataset; v...
asked by 18.05.2018 / 16:50
1
answer

How can I add this other property to my SQL Server query?

In ASP.NET WEB I am doing a search filtering for a table depending on the items you choose in 2 different dropdownlists. For now, I can make it work with one. SQLTable = "SELECT * FROM Mitabla"; SQLTable += "WHERE ID='" + Dropdownlist1.Selecte...
asked by 21.07.2018 / 05:42
1
answer

How to update a field Id

I have a migrated information to a table I need in that field to create a number that starts from the 16th and ends until the last record that is in that column.     
asked by 16.10.2018 / 05:58
1
answer

Help with subquery select Sql Server

Hi, I have a query to a SQL Server function and I need to show fields in a table in that same query. I did it like that but it shows me error. I also underline the query in red and a message appears that says: An insufficient number of arguments...
asked by 30.04.2018 / 18:57
2
answers

Pass data from one query to another activity, listview

I asked a question about how to pass data between activities, and they answered me well, but my problem now is that I do not need to pass a simple string or an integer, I need to pass a query SQLserver, put it in the intent and then pass it to t...
asked by 02.05.2018 / 10:50
1
answer

How to make a query to a case sensitive database?

I want to obtain the name that is associated with the user data and password in a table to which I make the following query in SQL Server. select Nombre from usuarios where NombreUsuario = 'UsuarioPrueba' and Contraseña = 'contRaPrueba'; T...
asked by 07.04.2018 / 01:47
1
answer

insert with select on sql server

I have the following code where I create a table and I want to insert information that came out of a query: CREATE TABLE AR_TABLA_REORI (TER VARCHAR(50),REG VARCHAR(50),ORIGEN INT, CLIENTES INT, TOTAL INT,SUCORIGEN INT) INSERT INTO AR_TABLA_R...
asked by 16.08.2018 / 23:48
2
answers

get id after inserting a record in sqlserver

How can I get the id of a record after it is inserted into a SQL table, I'm working with .net and sql server, if I have this stored procedure example CREATE PROCEDURE dbo.sp_Students_INS_byPK @student_id INT...
asked by 12.03.2018 / 21:35
3
answers

Search SQL Server table

I'm working with a database with a huge amount of tables and views. The program that calls that database peta and gives me an error when it tries to call a certain table. Is there any option to look up that table? Search engine or something?   ...
asked by 12.03.2018 / 12:24
1
answer

Modify SQL query to get response with desired structure

I am trying to create a query that allows me to show (in different columns) the budget for each month. This is the query I'm using: SELECT TOP 12 CL.Cliente_DS, EJE.Ejecutivo_DS, DS.Disciplina_DS, LN.Linea_Negocio_D...
asked by 07.03.2018 / 17:18