Posts by Andyson • 36 points

• 0

  votes

  3

  answers

  1806

  views

  A: SQL searching records from a Date and Time

  James, you can do something like this: SELECT * FROM tb_valores WHERE (DATA > '14/12/17' OR (DATA = '14/12/17' AND HORA >= '16:34:00')) This way the query will search all data with date is…

  mysql sql database select

  answered 7 years, 10 months ago Andyson 36

• 2

  votes

  1

  answer

  2160

  views

  A: How to remove a SQL Server Constraint

  From what I understand your Constraint is [FK_COD_RENDA_EXTRA] on the table Income. Change the name and table of the Constraint to perform the drop correctly, as this has to be done in the table…

  sql sql-server

  answered 7 years, 10 months ago Andyson 36