I have used the following simple query to retrieve datatypes from SQL Server 2000 tables:
where table_name = '<tablename>' and column_name = '<columnname>'
Along these lines, is there a way to retrieve datatypes from SQL Server stored procedures?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!