Question on SP - SQL Server Forums

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

Transact-SQL (2000)

Question on SP

Author

Topic

maryxu
Starting Member

36 Posts

Posted - 2009-09-11 : 11:19:57

I have a function created as GetEvDate,
then call SP test
exec test 'xxxx', GetEvdate('xxx')

but got error, how to fix this? thanks a lot

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2009-09-11 : 11:47:18

declare @a datetime
set @a=GetEvdate('xxx')
exec test 'xxxx', @a

"God does not play dice" -- Albert Einstein
"Not only does God play dice, but he sometimes throws them where they cannot be seen."
-- Stephen Hawking

maryxu
Starting Member

36 Posts

Posted - 2009-09-11 : 12:28:00

thank you

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources