sql oracle code to T-sql for sql server

• mtz676

  SSCrazy Eights

  Points: 9212

  More actions

  November 16, 2008 at 7:55 pm

  #196084

  DECLARE

  nId NUMBER;

  BEGIN

  INSERT INTO TABLE A (

  name,

  age

  ) VALUES (

  'X',

  12

  ) RETURNING

  ID

  INTO nId;

  INSERT INTO TABLE B (

  id,

  address,

  marital status

  ) VALUES (

  nId,

  'at home',

  'married'

  );

  END;

  Can anyone please convert the above code in sql to T-sql please . I hardly know T-sql.Thanks

• dhaneenja-755935

  SSC Veteran

  Points: 219

  More actions

  November 17, 2008 at 12:38 am

  #899189

  hi,

  try this way,

  --------

  DECLARE @NIDTBL TABLE(NID INT);

  DECLARE @NID INT;

  BEGIN

  INSERT A (

  NAME,

  AGE

  )OUTPUT INSERTED.ID INTO @NIDTBL VALUES (

  'X',

  12

  );

  SELECT @NID= NID FROM @NIDTBL;

  --SELECT @NID

  INSERT INTO TABLE B (

  ID,

  ADDRESS,

  [MARITAL STATUS],

  ) VALUES (

  @NID,

  'AT HOME',

  'MARRIED',

  ) ;

  END;

  Tharindu Dhaneenja.
  MCTS,MCITP(SQL Server),OCA(Oracle)
  http://www.databaseusergroup.com