A few days ago I saw a question that among other things implied a problem similar to the one I am going to raise, I wanted to do it in a more general way, because I understand that the well-thought-out solution could serve as a reference to simi...
Good morning, I have the following problem. In a sqlserver database, I have an entity with datetime fields, I generated 2 new date fields and updated my model from the database. The fields were imported without problems, I add them to the corres...
Apparently, there are two ways to create a temporary table in SQL-Server:
With a table variable ( table variable )
DECLARE @tmp TABLE (Col1 INT, Col2 INT)
or with a temporary table ( temporary table )
CREATE TABLE #tmp (Col1 INT, Col2...
I am working on a system with 15 concurrent processes that perform several operations against a SQL SERVER database, the versions can go from 2005 to 2014.
Each process has its particular data in several tables, no process queries / deletes / up...
I'm trying to connect to a SQL server from a machine with OS X , Capitan through FreeTDS > I made the installation with brew uninstall freetds , I made the changes in my file /usr/local/Cellar/freetds/1.00.24/etc/freetds.conf...
I am using ENCRYPTBYKEY and DECRYPTBYKEY but depending on the CONVERT that applies insert a null or else I get a truncation error
I define the following table:
CREATE TABLE [dbo].[Tracking](
[DataEncrypted] [...
I have the following query that I get with this query:
Select Año, Tip, Est, t1, t2, t3 From Tabla1
Año Tip Est Zo t1 t2 t3
2003 1 A 6 12 14 17
2003 1 A 7 12 15 18
2003 1 A 8 13 16 19...
Good I'm doing a form but in this case they fill certain data or they choose and a graph is generated and below a table that is basically the description of that graph and it is dynamic.
The problem is that when I press the first time it work...
I have a problem getting all the records of a query in SQL SERVER through PHP and AJAX.
When I send POST by the classic method of the form (submit), all records are displayed without any problem.
However, when doing the query by mean...
This is the error that ne comes up:
TITLE: Connect to Server
------------------------------
Cannot connect to DESKTOP-1N1OK6F.
------------------------------
ADDITIONAL INFORMATION:
Error relacionado con la red o específico de la instancia...