the cursor returned by using sp_describe_cursor_columns has a column called: data_type_sql which is smallint type? How can I obtain the data type name (like: varchar2 int etc) from data_type _sql intergers? I guess there should be a way to do, like from object_id to get object_name. Thanks!
【在 y****9 的大作中提到】 : the cursor returned by using sp_describe_cursor_columns has a column called: : data_type_sql which is smallint type? : How can I obtain the data type name (like: varchar2 int etc) from data_type : _sql intergers? : I guess there should be a way to do, like from object_id to get object_name. : Thanks!
Thanks. this is a possible way. 1> select name from sys.types where system_type_id=56; 2> go name ------------------------------------------------------------------ int i am looking for if there is a built-in function to convert 56 to int?
use the data type name directly, don't use ID. if you are looking up what type a specific column is SELECT t.name, c.name FROM sys.columns c INNER JOIN sys.types t ON c.user_type_id = t.user_type_id WHERE c.name = 'yourColumnName' and are you using osql?? that's old school and hardcore...
【在 y****9 的大作中提到】 : : Thanks. this is a possible way. : 1> select name from sys.types where system_type_id=56; : 2> go : name : ------------------------------------------------------------------ : int : i am looking for if there is a built-in function to convert 56 to int?
d*y
14 楼
搞定!多谢大侠~~~
【在 h*******e 的大作中提到】 : dvi2pdf时没有指定letter。
y*9
15 楼
I was using SQLCMD in SQL Server 2008.
【在 i****a 的大作中提到】 : use the data type name directly, don't use ID. : if you are looking up what type a specific column is : SELECT t.name, c.name : FROM sys.columns c : INNER JOIN sys.types t : ON c.user_type_id = t.user_type_id : WHERE c.name = 'yourColumnName' : and are you using osql?? that's old school and hardcore...