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 DataTable filled with a query, the problem is that in the database I do not have as many zeros as it shows in DataTable
How can I remove them?
In addition to this how can I edit some characteristics of DataTable...
I have a column called NOMBRE . In this there are three patients called "Juan". What I want is to distinguish them by adding a number followed after their name. Something like this:
Juan1
Or if there were 30252 records called Juan, pu...
In SSIS, I have a variable that takes the value of a query defined in a component "Execute SQL Task". The value of the variable is assigned correctly. What I want to do next is within a "Data Flow", using an "ADO origin", where the query is defi...
I need help, I'm making a connection to a SQL-Server 2012 database and visual studio 2013 and I want to make some reports with Cristal report but I do not know how to start, since I've never used that tool!
I am trying to migrate an Oracle database to SQL Server with the SQL Server Migration Assistant. Create the project and then when I connect to my Oracle databases I collect all the information and all the schemas are brought. There will be some...
I am importing a bacpac that I generated from the portal of Azure to a SQL Server 2012 local and I get the error that I detail next. Do you know how I can fix it so that the package is imported correctly?
TITLE: Microsoft...
I have to do a SQL Server 'job' scheduled for every day at 10 in the morning. The Work would be based on dump the data of a table of a database of a server in other 2 tables (with operations of by means) in another database of another server....
Good morning, I have the following query that makes me a query by dates to SQL SERVER:
$query="SELECT art_Clave, art_Costo, kar_Fecha, kar_Cantidad, kar_Origen, alma_Existencia FROM tArticuloKardex WHERE art_Clave='".$buscar."' AND...
I have a database in SQL Server and I am doing the inserts and updates to the database using the SQL Server syntax.
The request is, if someone can give me a code on how to filter a table at ComboBox and as the user typing the name, the...