Can we make parameter of a procedure of same type as that of data type of a column in a table in SQL SERVER ?
In Oracle we can do it as follow:
myVar IN mySchema.myTable.myColumn%TYPE
Can we make parameter of a procedure of same type as that of data type of a column in a table in SQL SERVER ?
In Oracle we can do it as follow:
myVar IN mySchema.myTable.myColumn%TYPE