Well, I get that error when it comes to opening the database, I checked the path and the database path is the correct C / Folder Database disk and that's where my database is located. sdf,
how can I solve it thanks
Let me explain: When I make a GROUP BY with MySQL, I can select fields that can not be grouped, as descriptions (varchars), and the result shows, of all the grouped values, the first one that I find.
But now I find SQL Server and it tu...
I am creating some reports and I really have no problem with the following query, as you can see it is simple and runs well but I realized that forget to put the " where " and it still works correctly; I had never seen anything like it b...
Dear, I would like to know if I can edit the option that appears when I right click on a table in a database in sql server 2008 "Edit the first 'x' rows".
What I would like to modify is to show me the rows ordered by one of the fields that I...
Dear, I have a problem when you want to update with SqlServer. I am developing a program with a DataSnap server and I have this problem when I want to update a field in the DBGrid.
I know that the error is in the key field of the sql query o...
I did a stored procedure to delete a table if it exists that is passed by parameter, this is my code:
create procedure CrearTabla
@Tabla varchar (100)
as
if OBJECT_NAME(@tabla) is not null
begin
drop table @tabla
end
go
But it...
Good day! I am creating a Bidirectional data synchronization application between a SQL Server Express and a remote server using the Sync Framework 2.1. The express is the client server and the remote is the server. When I provision the server fo...
I'm turning trying to pass an entire value to hh:mm format.
So far I managed to do /60 , passing the rest to minutes and casting everything in string format so that I keep the : in the middle. But I would need it to be i...
I have a following query
SELECT
A.IdDepartment,
A.IdParent,
A.Localidad,
A.Codigo,
A.Nombre,
A.Departamento,
A.Fecha
FROM VW_HORARIOS A
INNER JOIN VW_DAY_WORK B ON A.Codigo = B.Codigo AND A.Fecha = B.Fecha
GROUP BY...