Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Database & SysAdmin
  3. Database
  4. how to write the querry for copying one image field into another image field in sql server 2000

how to write the querry for copying one image field into another image field in sql server 2000

Scheduled Pinned Locked Moved Database
databasesql-serversysadmintutorialannouncement
2 Posts 1 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • D Offline
    D Offline
    developerit
    wrote on last edited by
    #1

    hi iam using sql server 2000 i have table images brabchid nvarchar(50) imagenew image imageold image at the first time iam storing image in imagenew field then by using update querry i want to copy imagenew field data into imageold field and in imagenew field iam storing new image but it is showing same images can you correct my querry update images set imageold=imagenew ,imagenew=@imagenew where branchid=@branchid

    D 1 Reply Last reply
    0
    • D developerit

      hi iam using sql server 2000 i have table images brabchid nvarchar(50) imagenew image imageold image at the first time iam storing image in imagenew field then by using update querry i want to copy imagenew field data into imageold field and in imagenew field iam storing new image but it is showing same images can you correct my querry update images set imageold=imagenew ,imagenew=@imagenew where branchid=@branchid

      D Offline
      D Offline
      developerit
      wrote on last edited by
      #2

      hi , sir iam waiting for your reply

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups