DBMS: SQL SERVER 2014 + MySQL 5.5
What are the SELECT, INSERT, and UPDATE syntax instead of using the "OPENQUERY" function, when connecting through the SQL Server Linked Server, connecting to MySQL?
Galera, in the query below is bringing as follows. But I want you to bring only the 'YES'. The difficulty is because it is a subselect with case. I bring you where? No where or a having? How would it be more or less
Current Result
Client...
I want to add the col3 fields by checking that the col2 value is the same as the following by doing a sequential group by.
col1 col2 col3
ind seq1 5
ind seq1 3
ind seq1 7
ind seq1 4
ind seq2 5
ind seq3 1
ind seq3 3
ind se...
I'm creating an academic system that consists of a virtual restaurant menu type, so I've created three tables in the database:
Menu Items Table:
CREATE TABLE ITEMS(
ID INT PRIMARY KEY NOT NULL,
NOME VARCHAR(20) NOT NULL,
DESCRIC...
In the query below the following error occurred:
Converting a varchar data type to a smalldatetime data type resulted in a value out of range.
By analyzing, I realized that if I take out the dbo.FN_CALC_HORAS_UTEIS function, it...
I have an application developed C# using the Windows Forms project that displays the Database People Table in a list in the DataGridView field. However I need to display in the DataGridView also the Endereco ta...
It was suggested to partition the main table of my system to improve the performance of some queries.
The dev that made the suggestion suggested using the ano registry information to partition, because as the system has not been runnin...
I want to perform a calculation using the value of the field VAL_VIDA_UTIL of my BD and then save the result from calculation in a new variable VAL_DEPRECIACAO and pass to my fieldName, but I am not succeeding. Could someone help me?
My code...
I need to create a script to check if a table has primary key , if it does not, it is added to primary key .
I found this form to do the script, I did not understand where it takes the name of this table "INFORMATION_SCHEMA.TAB...