SQL Server Performance

Using SP in query clause.

Discussion in 'T-SQL Performance Tuning for Developers' started by boldhead, Jan 21, 2004.

  1. boldhead New Member

    I used function in the query clause. I wander if anybody used stored procedure as part of the query clause.

    Thanks,
    Davis
  2. Twan New Member

    you can't use a stored procedure as part of a query clause... the only exception is insert into...exec

    Cheers
    Twan
  3. boldhead New Member

    That is what we concluded from our tests. Thanks for confirming.

    Davis

Share This Page