Post reply

help with sqlcmd

  • October 31, 2007 at 8:49 am

    #183500

    Ok here is an issue I am having, I wrote this query using sql, But i think i need to convert it so that it will run in the cmd prompt. Can someone please let me know what i have to do to get this to run in the cmd prompt. Some Help would be great, Esp if your able to convert this quickly

    use "washco redtitan"

    Bulk Insert test2

    FROM 'C:\Documents and Settings\test\Desktop\WashingtonXMLScriptssample\washco911.csv'

    WITH

    (

    FirstRow=2,

    FIELDTERMINATOR = '","',

    ROWTERMINATOR = ''

    )

    UPDATE dbo.test2 SET Program = REPLACE(Program, '"', '' )

    update dbo.test2 SET FileName=Replace(FileName, '"','')

  • October 31, 2007 at 10:31 am

    #747166

    Use sqlcmd command line utility

    --Ramesh

  • October 31, 2007 at 10:33 am

    #747168

    and this will translate it?

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

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