I need to get the available records between two DATETIME columns in SQL Server, so that one column is the beginning and the other the end.
That is, when making a query based on both values, get the data that are in the range of the DATET...
Hello, I was looking for how to change this syntax from sql server to oracle and I still do not understand the structure that oracle has in its bd.
The sql server syntax:
USE [BD]
GO
/****** Object: User [pepe] Script Date: 06/05/2017 1...
I have been working a bit with MySQL and SQL Server, and I have a question: si el script "Missing Index" existe en MySQL
In SQL Server I know that it shows the missing indexes of each table in a database, and for that I would like to k...
I have the following problem. I have a procedure in SQL Server 2008 that has a Cursor. The actions that are executed within the stored procedure are within a transaction to cancel it in case of error, because if only one of them fails, I must ca...
I have a view in sqlServer in which I do the following select
SELECT mes
,P117_Dias_Trabajados
,P004_Dias_Falta
,P002_Dias_Permisos_CG
,P003_Dias_Permisos_SG
,P003_Dias_Licenicas_Comun
,P003_Dias_Licencias_L...
Good in itself is the following, I have a membership application in c # that handles reports and obviously a Database, my question is the following as I can do so that when the installer of the application install sql server is created automatic...
using the postgresql importer 9.4.6 the Migartion Toolkit v49.0.4-2
this command was used
runMTK.bat -sourcedbtype sqlserver -targetdbtype postgres -allTables -targetSchema public dbo
and for lack of several files .jar gives error of:
...
Some of you have seen this error:
The log scan number (35: 295: 1) passed to log scan in database 'model'
is not valid This error may indicate data corruption or that the log
file (.ldf) does not match the data file (.mdf). If this err...
I would like to open my pdf file that I stored in my sql table with the following fields: nombre(varchar),tipo(varchar),ruta(varbinary) . How would it be?
So I have it but it only brings me the name as I open the pdf ???
function OnSu...
I mean, I have a string of numbers that seems like they are not, but a chain is reproduced in the following way:
1881181818181818181800
What I need is to make a selection in the second pair of numbers that would be 81 search for number 81 b...