Someone knows in sql server theme, how to join a result that gives me from 3 rows to a single row I'm using this query but it does not attach them to me in a single result, something when I do an XML result but with some function .
SELECT ER...
I hope you can help me with the following code that I have in visual studio, I am programming a user login, in asp.net with c # and it turns out that in my aspx form called PortalAlumons.aspx.cs I wrote the following code:
protected void P...
I have my server linked to another server, what I need is a stored procedure where at the moment of inserting data in a table of my server at the same time insert in another table of my linked server
What is the correct syntax in a select using SQL SERVER?
SELECT columna FROM [basedatos].dbo.tabla AS tb WHERE condiciones
O
SELECT columna FROM basedatos.dbo.tabla tb WHERE condiciones
Can you use aliases?
Are brack...
How can I save data within a table according to the condition?
this in my code:
List<USUARIO> usuarioList = new List<USUARIO>(); //instanciar la tabla usuario
int numDía = 0;
DateTime diaAnterior = Date...
I have the following Query with which I get the number of times that is repeated every id_turner in my table rol_por_tercero .
use DatabaseName
select id_tercero,COUNT(*)CantidadRepetidos from rol_por_tercero group by id_tercero havin...
I am working in C # with MVC and I am saving text in SQL server but I need to do line breaks so I chose to include the <br/> tag to perform the jumps, from a view I made the insertion in the data base and another view I show that da...
I have my next table called LIST with two columns: Id, and Name, in the Name column I have 4 data: Notes, Agenda, Authorization and Membership.
public IQueryable Listar1()
{
return from titus1 in Contexto.LISTA...
Greetings.
I have been investigating the following error that appears to me when running a web page that I am programming in VS2013
Server error in the application '/'.
Error related to the network or specific to the instance whil...