I want to declare a local var. in sp. such that it would have the same datatype as a column in a specific table
Example (forgive the syntax!)
Decalre @Address CustomerTable.Address
The above would translate to the following at execution time
Declare @Address VARCHAR(200)
This feature was in Oracle, is it in SQL Server as well?
View Complete Post