Home

Access syntax migrating to T-SQL

%3CLINGO-SUB%20id%3D%22lingo-sub-394313%22%20slang%3D%22en-US%22%3EAccess%20syntax%20migrating%20to%20T-SQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394313%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20migrating%20an%20insert%20statement%20and%20came%20upon%20what%20looks%20like%20Access%20syntax.%3C%2FP%3E%3CP%3EWhile%20I%20scratch%20my%20head%2C%20%22Why%20does%20that%20look%20like%20a%20column%20update%20inside%20an%20insert%20statement%3F%22%3C%2FP%3E%3CUL%3E%3CLI%3EWhat%20would%20be%20the%20appropriate%20translation%20T-SQL%20Statement%3F%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3Emy%20guess%20is%20get%20rid%20of%20what%20looks%20like%20the%20SET%20operation%3C%2FP%3E%3CP%3E%3CEM%3Eround(GreenSampleWeight....)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20it%20looks%20like%20in%20the%20GUI%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20294px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F101714iDBCD01CE0A397958%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20what%20it%20looks%20like%20in%20T-SQL%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20635px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F101713iFEDAA5A0F062DBBB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture2.PNG%22%20title%3D%22Capture2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-394313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ET-Sql%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
dianagele
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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies