I have this code to insert values into a column of a table:
conn.Open();
comm.CommandText = @"INSERT INTO ArticleBarCode(Code, Code_Article, BarCode, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn, IsDeleted)...
I would like to know what I do:
I want a variable of type days
Then get the result of this variable and make a select between the dates counting the number of days
Any solution or example?
I have a project under development on this internship and so I am working on new things. I would like to know how I can do in C # a data query present in SQL Server tables. Sorry if you're being too lazy.
I try to connect the java with the Sql Server from my local machine but I get this error
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost,
port 1434 has failed.
Error: Connection refused: connect. Pl...
I have a query and it returns the following table:
I would like to know if you can add another line (in this case 3) to make the difference between the two years.
I wanted a new line that would give the difference of the two values o...
I have the following SELECT in SQL Server
SELECT FTags.DateAndTime, TAGS.TagName, TAGS.TagIndex, FTags.Val
FROM TagTablePoços TAGS INNER JOIN FloatTablePoços FTags ON FTags.TagIndex = TAGS.TagIndex
WHERE TAGS.TagName = '[AGUA]FT[1].O...
I'm mounting an SQL statement using
Message 530, Level 16, State 1, Line 5 The statement was terminated. THE
maximum recursion 100 was exhausted before the end of the instruction.
SQL Server version:
Microsoft SQL Server 2016 (S...