Post reply

Convert Access Query to TSQL Update Script

  • March 6, 2008 at 1:04 pm

    #69982

    What would be the best way to convert the following Access code:

    UPDATE dbo_ClippershipImport SET dbo_ClippershipImport.TRACK_NO = Right(Trim([track_no]),12)

    WHERE (((dbo_ClippershipImport.TRACK_NO) Is Null And (dbo_ClippershipImport.TRACK_NO) Like "019*"));

    To a function Update script in TSQL?

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

  • March 6, 2008 at 1:20 pm

    #786329

    I'm not quite sure what you mean by a "function update script" - but the UPDATE clause is alive and well in SQL Server.

    yours looks something like

    UPDATE dbo.ClippershipImport

    SET TRACK_NO = right(rTrim([track_no]),12)

    WHERE dbo.ClippershipImport.TRACK_NO Is Null

    And dbo.ClippershipImport.TRACK_NO Like '019%';

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply