Q:
Is there a query to retrieve datatypes from SQL stored procedures?
I have used the following simple query to retrieve datatypes from SQL Server 2000 tables:
select TABLE_NAME,
COLUMN_NAME,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH
from <tablename>.information_schema.columns
where table_name = '<tablename>' and column_name = '<columnname>'
Along these lines, is there a way to retrieve datatypes from SQL Server stored procedures?
select TABLE_NAME,
COLUMN_NAME,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH
from <tablename>.information_schema.columns
where table_name = '<tablename>' and column_name = '<columnname>'
Along these lines, is there a way to retrieve datatypes from SQL Server stored procedures?
ASKED:
Jan 7 2009 4:41 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
