Access syntax migrating to T-SQL

Regular Visitor

I am migrating an insert statement and came upon what looks like Access syntax.

While I scratch my head, "Why does that look like a column update inside an insert statement?"

  • What would be the appropriate translation T-SQL Statement? 

my guess is get rid of what looks like the SET operation

round(GreenSampleWeight....)

 

This is what it looks like in the GUI:

Capture.PNG

This is what it looks like in T-SQL

Capture2.PNG

0 Replies