Questions tagged as 'sql-server'

Tagged questions
1
answer

Connect server DB to desktop application in C #

I just finished my application which I developed in C # using windows forms, it is a desktop application, which works with a local database. The application will be installed in clothing stores outside the company. My question is: How can I c...
asked by 30.08.2018 / 01:53
4
answers

How do I get this date format in Sql Server 2014?

I am having problems when formatting a date in SQLSERVER, my query is SELECT CONVERT(VARCHAR(10), FECHA_INI_FALLA, 13) AS FechaFalla and the result I get is 12 SEP 2017 and what I want to get is 12/SEP/2017 O 12-SEP-2017 It should...
asked by 12.09.2017 / 18:48
1
answer

How to rename columns of a sql table using a query

Even if you miss an error, make the changes. The question is simple, instead of modifying the table from the designer, I want to do it from a query. I have found how to modify the type, the description ... except the name! I have tried...
asked by 07.07.2017 / 09:23
1
answer

Delete the last two characters of a sql server string

I use SQL Server 2000 and I have a table with a field rut of type VARCHAR (eg: '17045782-8' I need: '17045782') to which I have to remove the check digit and the hyphen. And I do not find it with substring(rut,0,x) since the...
asked by 24.03.2017 / 14:55
3
answers

Error saving data in SQL Server

I have been struggling with this problem for several days to see if they could give me a little help. I have this error:    "Unable to insert the NULL value in the 'CODE' column, table   'C: \ USERS \ MAICOLODALIS \ DOCUMENTS \ VISUAL STUD...
asked by 18.04.2016 / 07:28
1
answer

Because it does not give the sum of names in MySQL

I have the following: CREATE Table apellidos_completo (Completo varchar (255)) INSERT INTO apellidos_completo (Completo )values ('alvarez') UPDATE apellidos_completo set Completo = 'Rodriguez' + Completo I do SELECT SELECT * FROM apel...
asked by 30.06.2018 / 05:02
1
answer

Error when inserting in the Sql Server 2016 Database?

I have tried to store values in my database and I have run into a problem I am handling Laraver 5.5 and SQL Serve 2016 "message": "SQLSTATE[23000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]No se puede insertar el valor NULL en...
asked by 13.06.2018 / 17:37
2
answers

delete repeated values sql server

I have a problem in a sql server query ... I have this table where I need to delete repeated values (those marked in blue) due to the last column ('hh''mm') and try the DISTINCT but even so he shows them to me I do not know if I made my...
asked by 26.10.2018 / 20:46
3
answers

Validation, Filter results in SQL

Good morning, I have a query that returns values of several functions and I need to filter it with another table B since I do not want it to show the record if it exists in table B This is the query I want to filter SELECT FormaPago, NDCH, CO...
asked by 24.11.2016 / 16:09
2
answers

Subtract hours from two columns datetime sql server

I'm doing a query in sqlserver 2000, I have two datetime columns (start, end). I need to subtract the two columns to know how many minutes passed between the start and the end, something like: select end-start as time_wait from myTable hel...
asked by 09.06.2016 / 17:23