When I run the following query in SQL Server 2014 to create a temporary table:
CREATE TABLE #temp
(
location char(16) null,
location_desc varchar(25) null,
Emp_Num EMPNUM null
)
I receive the error:
Cannot find the data type empnum.
empnum is a user-defined data type. But the same user-defined data type is working fine in other stored procedures.
Why am I receiving this error?