Home Forums SQL Server 7,2000 T-SQL Convert my syntax - Oracle SQL to MS SQL Server RE: Convert my syntax - Oracle SQL to MS SQL Server

  • November 29, 2006 at 6:32 am

    #674628

     

    UPDATE table2 SET c = CAST(table1.c AS VARCHAR(255))

    FROM table1 WHERE table1.a = table2.a and table1.b=table2.b

    this actually takes more time (compared to the procedure)!

    Is there a bulk update! in ms sql server?

    Regards,

    Srinidhi Rao