Posts by José • 1 point

• -4

  votes

  2

  answers

  58

  views

  A: Import Excel data to table in SQL Server (only data other than that already in the table)

  Use Msaccess and import excel to Msaccess. Next export Msaccess to SQL. When you already have in SQL do the validations in the database before inserting

  sql sql-server excel

  answered 3 years, 3 months ago José 1

• -3

  votes

  2

  answers

  59

  views

  A: I’m a beginner in SQL. I need to build an Insert that will validate some fields of the source table and fill in the target table

  Selects before inserting. In select you validate the records to be inserted, and then do the Insert

  sql oracle

  answered 3 years, 3 months ago José 1