function call - 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

General SQL Server Forums

New to SQL Server Programming

function call

Author

Topic

ag_ss
Starting Member

48 Posts

Posted - 2006-03-28 : 01:53:09

can i make a function call from stored procedure

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-03-28 : 01:54:51

You mean using function inside a stored procedure ? YES

KH
Choice is an illusion, created between those with power, and those without.
Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant

ag_ss
Starting Member

48 Posts

Posted - 2006-03-28 : 02:07:08

exactly
thanx

a_r_satish
Yak Posting Veteran

84 Posts

Posted - 2006-03-28 : 04:38:02

Ya surely possible.

Take for example:
Create procedure builtin
as
begin
select fn_test()
end

exec builtin
=> ll call the function inside the stored procedure automatically.

Regards,
satish.r
"Known is a drop, Unknown is an Ocean"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources