Converting from Oracle to SQL Server

• Dave-352614

  Grasshopper

  Points: 11

  More actions

  July 27, 2006 at 1:09 am

  #173643

  Hello. I'm new to SQL Server and need some assistance, if any of you kind people can help. I need to translate the following from Oracle to SQL Server:

  SET VERIFY OFF

  ACCEPT oldlocal PROMPT "Enter the Set ID to change: ";

  ACCEPT newlocal PROMPT "Enter the new value: ";

  update bank set local_acc_no = '&newlocal' where local_acc_no = '&oldlocal';

  Thanks in advance

  Dave

• Roy Rogers

  SSCertifiable

  Points: 7712

  More actions

  July 27, 2006 at 6:59 am

  #651863

  SET VERIFY OFF - Not available SQL Server

  Rest it is not possible to get user inputs by prompting in T-SQL Query Analyzer. You may need a seperate Application to do that.

  I would some thing like this

  update bank set local_acc_no = 'You New Value' where local_acc_no = 'Your Old Value'

  OR for multiple updates

  DECLARE @Alters TABLE

  (

  newlocal Varchar(100),

  oldlocal VarChar(100)

  )

  INSERT @Alters

  SELECT 'Your Old Val 1', 'Your New Val 1' UNION

  SELECT 'Your Old Val 2', 'Your New Val 2' UNION

  SELECT 'Your Old Val 3', 'Your New Val 3' UNION

  SELECT 'Your Old Val 100', 'Your New Val 100'

  UPDATE A

  SET

   local_acc_no = newlocal

  FROM

   bank A

  JOIN

   @Alters B

  ON

   A.local_acc_no = B.oldlocal

  Regards,
  gova

• Bhushan

  Default port

  Points: 1427

  More actions

  July 27, 2006 at 10:09 am

  #651929

  You can try with SQLCMD