Forum Discussion

dianagele's avatar
dianagele
Copper Contributor
Apr 04, 2019

Access syntax migrating to T-SQL

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:

This is what it looks like in T-SQL

No RepliesBe the first to reply

Resources