I have the following query in sql sever 2014
CREATE TABLE #TEMPTABLE
(
ID INT,
DATACOLUM VARCHAR(5)
)
INSERT INTO #TEMPTABLE VALUES
(1,'A'),(1,'B'),(1,'C'),(2,'D'),(3,'E'),(4,'F')
SELECT
TB.ID,
STUFF((SELECT ',' + D...
I have a development in visual studio that makes backups of the database of a SQL Server 2014 Standard Edition server, after making the backups there is a routine to be able to compress them and leave them as .Gz files:
The backups are made w...
I am migrating to SqlTableDependency to get notifications of changes to the database on my asp.net mvc web system. Previously, I used SqlDependency to get the notifications, but I found it more useful to do that migration.
The problem is a li...
Here I bring my problem.
I use SqlServer 2014 and VisualStudio 2015
I have an Object named CashRegister which has these attributes:
public class CashRegister
{
private static CashRegister CashRegisterInstance;
public int? Id...
I'm doing a job for the university where I have to do a travel management system, where I have tables such as Pasajeros , Viaje , Boleto etc. Now I must make inquiries based on this basis that I created.
A particular query...
Hello colleagues I have this query that works well to find the difference between two dates in days, hours, minutes and seconds but when I pass it to the trigger it does not work anymore I get a number 4873 I do not know what I'm doing wrong, my...
I need to create a procedure that creates a new table from the selection of one or several entities. The selection of 'IdEntity' I do from a gridView in the presentation layer in Visual Studio.
What I have is this:
CREATE PROCEDURE [dbo].[sp_...
I run out of a computer and I'm using another, one with window8.1 and I can not install sql server 2014. I open the microsoft page and the page is down ... I'll download and it's blank .. two days ago I'm wanting to install the sql server and I...
If you could help me, I have a table like this:
identificativo fecha
72028586 11/05/2018
72028586 13/05/2018
72045976 17/05/2018
72063798 13/05/2018
and I need to make a query to show me th...