Questions tagged as 'sql-server'

Tagged questions
2
answers

some idea how to select a round numbers in sql server

Someone has some idea of how to select from a table round numbers. I would be grateful for an example or some idea so I can implement it in my BD THANK YOU ...     
asked by 07.11.2018 / 20:26
1
answer

What is the SQL server that has the option of Email from service?

I have a Db with many emails I want to use the SQL server to send publicity mail to all the registered ones The problem is that my SQL server is 2008R2 but I think it is the express or something like that it does not have the options of Mail in...
asked by 21.10.2018 / 19:15
1
answer

I can not open SQL Server [closed]

I am installing SQL Server, but I get an error when opening it. What can I do?     
asked by 13.04.2017 / 00:25
1
answer

PL SQL statement error

I have to make an insert in SQL Server. I have tried the following, but I do not know if it will be fine, at first glance it gives me a fault near the IF and the THEN , but I do not know why. I imagine it will be for the AND...
asked by 11.04.2017 / 09:36
1
answer

Unify 2 records in 1 - SQL SERVER 2014 [closed]

Good morning, I have 2 records that are almost identical, where they only differ in 1 column. What I would need to do is have a single record with the fields that differ. In the image what I have (The two registers above) and what I nee...
asked by 02.01.2018 / 17:12
2
answers

Error editing a visual studio project in another pc

I'm developing a project in Visual Studio and this project I'm continuing on a new PC, my problem is that when I run the project to know how it goes I get the following error.     
asked by 23.10.2018 / 23:44
1
answer

Delete row from a table with php

Hello good afternoon again in the forum and I have the following question. I have this code that loads everything in the database into a table, the problem is when deleting by ID ... Thanks in advance. <form name="frmInsertarFecha" ac...
asked by 23.10.2018 / 20:48
1
answer

SQL Managment starts and before login closes

The query is the following: Why does SQL start and before showing me the login closes alone? Context. Install Sql Server - Sql Managmente Studio 2018. It worked perfect, I was working until a few days ago. I connect to the database of the w...
asked by 01.11.2018 / 15:34
1
answer

Do not throw me the expected result when I use the inner join

the first code brings me the result well select t.TransaccionId, t.NetAmount, t.UserId, t.Id_movimiento, t.CreatedDate from TablaPrincipal t where id_movimiento is null the second code select t.TransaccionId, t.NetAmount, t.UserId, t.Id...
asked by 06.11.2018 / 21:49
1
answer

LINQ stored procedure

I'm calling a stored procedure through entityframework but I get an exception When passing the parameters exp="tblAdquiridosGe" _cFiltros="'d.cNombre = ''DE'''" return contexto.uspBusquedaCliente(exp,_cFiltros) But when I run th...
asked by 22.08.2018 / 18:15