how to convert this declaration of variables Oracle to Sql Server

Question

this is the code in Oracle:

  pUsuario             IN     SAV_CAMPANAS_ENCA.USUARIO_CREA%TYPE,
  pCodTipo             IN     SAV_TIPOS_CAMPANA.COD_TIPO%TYPE,
  pCantidadRegistros   IN     SAV_CAMPANAS_ENCA.CANTIDAD_REGISTROS%TYPE,
  pPrograma            IN     SAV_CAMPANAS_ENCA.PROGRAMA%TYPE,
  pCodPais             IN     SAV_PAIS.COD_PAIS%TYPE,
  pNumeroIntentos      IN     SAV_CAMPANAS_ENCA.MAXIMO_INTENTOS%TYPE,

I'm pretty sure there is no equivalent for %TYPE in T-SQL, but then I haven't used SQL Server for along time (let alone stored procedures) — user330315
– user330315, Commented Jan 29, 2015 at 22:50

Justin Cave · Accepted Answer · 2015-01-29 22:55:02Z

1

SQL Server doesn't have anchored type declarations-- you can't do the equivalent of <<table>>.<<column>>%TYPE. You'd need to determine the actual data types of the underlying columns and use those. Of course, that means that if you change the data type of some column, you'd need to go through your code to change the data type of the variables that need to reference that column.

answered Jan 29, 2015 at 22:55

Justin Cave

233k25 gold badges378 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to convert this declaration of variables Oracle to Sql Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related