Home Forums SQL Server 2008 SQL Server Newbies Conversion failed when converting the varchar value ' WHERE statusID = 1' to data type int. RE: Conversion failed when converting the varchar value ' WHERE statusID = 1' to data type int.

  • September 27, 2013 at 1:58 am

    #1653898

    More insecure dynamic SQL....

    Please, do you company a favour and stop writing dynamic SQL until you've read up and understand SQL injection.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass