Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Another Recruiter Asks a SQL Question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-22 : 06:50:27
gouree writes "Hi with respect to the question posted "Another Recruiter Asks a SQL Question"
I want to use the inoformation_schema inside the function in the exactly similar manner as shown in the article, but I am using a function and so I cannot use an EXEC in it.
Any other way that I can get the coiumn value inside the function ?"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-25 : 10:09:01
You need to use Stored Procedure than Function
Similar to the one specified here
http://sqlteam.com/forums/topic.asp?TOPIC_ID=53384

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -