I have a VPS with Windows Server 2012 and with SqlServer already installed. And I developed a Website with connection to BDD on my local PC. The connection string that I use, I generated with Visual Studio when connecting a table from the same IDE.
In my VPS I cannot install other programs , is there a way to obtain the Connection String, only with the SqlServer or SqlManager?
Good morning community.
I need to make a query in SQL (Sql Server 2012) to filter by a range of dates (StartDate - EndDate).
The table is as follows:
ARRESTS
ID
ESTADO
EQUIPO
FECHAINICIO
FECHATERMINO
The Problem, is that sometimes the Field FECHATERMINOmay be NULLbecause it is still "stopped" to date according to my business logic.
SELECT * FROM DETENCIONES WHERE EQUIPO=1
AND @FECHA >= FECHAINICIO AND @FECHA <= FECHATERMINO
I already tried with an OR but it returns all the TEAMS that have a NULL in their end date, that is, it does not respect the parentheses.
SELECT * FROM DETENCIONES WHERE EQUIPO=@EQUIPO
AND @FECHA >= FECHAINICIO AND (@FECHA <= FECHATERMINO OR FECHATERMINO=NULL)
PS: I visualize the data in a Website created with ASP.NET C#.
In Excel 2016 it is supposed to have the function SI.CONJUNTO
which is like a switch in programming.
I have tried to write it in English SWITCHor CAMBIARbut it does not appear.