I am trying to create a inline function which is listed below.
while executing this function in sql server 2005 my get this error
CREATE FUNCTION failed because a column name is not specified for column 1.
Pleae help me to fix this error
You have to specify an alias for the columns in the select statement. Change the query to somthing like this:
SELECT ident_current('orders') AS 'ID'
I hope this answers your question.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?