I have a name field in a table that has the following data:
1-Course
2-Course
10-Course
When sorting by name it returns 1,10,2 . How to order to bring: 1,2,10 ?
Ps: The field is NVARCHAR .
I'm using the following LINQ to return a query:
.Where(c => c.Nome.Contains(nome)).OrderBy(c => c.Nome)
But if the name is Maria , it brings:
José Maria
Maria José
How to bring organized as if executing SQL query? So:
WHE...
Good morning, I have the following doubt, I work in a company where the staff fills up when it comes to using inner join for efficiency and database processing, I wonder if the relationship between tables done no where is really "b...
How to call a procedure in ASP.NET C #?
Here's my simple procedure:
CREATE PROCEDURE GetAdmin
(
@email VARCHAR(50),
@password VARCHAR (50)
)
AS
BEGIN
SET NOCOUNT ON;
SELECT * FROM Admin WHERE Email = @...
I make a query in a table in my MySQL database that returns the following fields: usuarioId nome sobrenome idade sexo escolaridade modeloNome hora
Follow the sql below:
SELECT
sv...
So ... I have a table that has a sequenc , a num , a dt_inicial , and a dt_final .
My question is: how to make a Select that takes the data between dt_inicial and dt_final showing num between...
I'm trying to remove the use of SQL statements from within the system (to make it flexible on the database that will be used), I use statements Insert , Update and Delete via stored procedure (for performance and for flexibi...
I found in the SO a question with an answer well accepted by the community #
But I never had problems with double for monetary calculations, I had yes with float that already left my hair standing, then from this answer stating...