August 6, 2002 at 12:41 pm
What is this? How is it used?
Thanks for the help.
August 8, 2002 at 6:43 am
Actuall I encountered it when I was creating a table using Query Analyzer. I was going to name a column type_name and when I type it, it turned pink signifying that it was a function of some sort. I looked in BOL and there is nothing about a function called type_name. I was curious what it is used for. Any help would be greatly appreciated.
thx, scott
It would help if you could specify the context in which you encountered type_name.
Probably the most likely context where this is used is in reference to specifying a valid SQL Server data type. SQL Server data types have names and these names are referred to as type_name in BOL.
HTHs solart
Edited by - solart on 08/07/2002 10:53:12 AM
[/quote]
August 13, 2002 at 1:38 pm
This is a function that returns the type name of a column. For example, if you execute this command in Query Analyzer: "select type_name(175)" it will return "char". These types are stored in a table called spt_datatype_info of database Master.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply